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).
Hey Luiggi, thanks for the reply - i am using v45.2. Ive set a complex default value for a single date filter within the SQL using optional clauses and the database's "comment" method. When I do this, I still dont see the value populating in the filter. If you can point me in the direction where this release note was created I can modify my solution- Thanks!