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
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'
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()).
Yes, but this will work at a look level only.