I was wondering if there is a way to set the dashboard “single date” filter to the current date.
Maybe I could put this in the native query itself to pick current date if no date is selected, however, considering I have many different questions on a dashboard aggregating over that date and/or making various decisions reliant on that date, the amount of places where I would have to annotate the current date would be extremely cumbersome.
I just want the dashboard “single date” filter to be set to the current date so the initial view of the dashboard shows values based on the current date.
Ideally, I would like to be able to select the default value of the dashboard filter to be (curdate() - interval 1 day) (sql language) or yesterday (normal people).
Any support would be greatly appreciated.