Omitting Certain Weekdays

[joeconti55]

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).

[IanT]

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

[joeconti55]

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