Setting range filter dynamic default

[smadarsbdsbdsbd]

Hey all,

I have a range filter on a dashboard, and I want it to always show until yesterday.

example: if today is the 20th, the default should be set to 19th. On the 21st, it should be set to 20th.

Thanks

[Shru]

Date range filter may not exactly work for your requirement. You can use the below option as a workaround.

Create a YesNo type dimension with sql logic {$view_name.date_column}<current_date()

Pass this dimension in the dashboard and keep default selected value as 'Yes'

[smadarsbdsbdsbd]

Hi, 

Thank you for the answer, I think I can use it with day of month.

like: extract_day({$view_name.date_column})<extract_day(current_date()).

[Shru]

Yes, but this will work at a look level only.