Question

Omitting Certain Weekdays


Is there a way to omit specific weekday(s) in a custom filter?  For example, we do not do business on Sundays, so our daily data is very spiky over time as it always goes to zero on Sunday (this is great in some cases to see where the weeks change, but it would be good to filter these out in some cases as well).


2 replies

Userlevel 6
Badge

date dimension groups can have a timeframe of day_of_week_index which you can filter out 6 (sunday)

https://docs.looker.com/reference/field-params/dimension_group#timeframe_options

 

Thanks for your response, Ian.  Very useful to know we can add a day_of_week_index for filtering.  Thanks!

Reply