How to get max value in prompt default filter
I have selected a date column in prompt and for "default filter" , I am using "$currentDate".
Existing Scenario : sometimes due to load timings data for $currentDate is not yet populated. Hence with default values my dashboard will display null records. After which I select different date, It will display record.
My requirement is, instead of $currentDate, I need max(date_col) in prompt default filter option
This video shows how to store Max Date in a session variable and use that to filter data using Max Date.
In your case, you can use session variable to default to Max Date.