Showing results for 
Search instead for 
Did you mean: 

Select Latest date as filter automatically on refresh

7 - Data Storage
7 - Data Storage

I have a date column. I want the latest date to be automatically selected as a filter, also giving user the ability to select any date.

After the cube refreshes, if the latest date changes, the new date should be automatically selected, the previous date to be unselected. It should look and behave like a normal filter in which users can choose any date they want but it should also automatically give them the latest available date's data.

Please help.


11 - Data Pipeline
11 - Data Pipeline


What you can do is modify the selected default value to point to today's value as seen in the attached image.


In general, I highly recommend you to check out our "date range filter" premium plugin as it holds many date selection and manipulation features:

If you have any further questions feel free to contact us:

[email protected]