Advanced time range: search business hours only

[MathieuM]

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

For example 9 to 5pm Monday to Friday? 

[Dawid]

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

[IanT]

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.