Advanced time range: search business hours only

  • 10 February 2022
  • 2 replies

Hello, is it possible to search in business hours only?

For example 9 to 5pm Monday to Friday? 

This topic has been closed for comments

2 replies

Userlevel 7
Badge +1

It is possible but not using anything ready-made in Looker. You could create a dimension “business_hours_only” and make it a filter-field only, then you would need to use Liquid statements to reshape the definition of your timestamp


-- I overcomplicated it, IanT is right here..if it’s just about the filter then of course you can use the hour_of_day and then day_of_week in filters. Or going the same direction use it to create boolean field and filter measures in your LookML

Userlevel 6

you can filter on the hour of day timeframe (if its been exposed in your date dimension group) for between 9 to 5 for example.