cancel
Showing results for 
Search instead for 
Did you mean: 

Select Latest date as filter automatically on refresh

princepatni
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.

1 REPLY 1

Benji
7 - Data Storage
7 - Data Storage

Hi,

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

Benji_0-1663833337138.png

In general, I highly recommend you to check out our "date range filter" premium plugin as it holds many date selection and manipulation features:
https://www.sisense.com/marketplace/date-range-filter

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

inquiries@paldi.solution