cancel
Showing results for 
Search instead for 
Did you mean: 

Choose the latest date available in a dashboard filter

analytik
7 - Data Storage
7 - Data Storage

Assume a date dimension. It contains a series of dates. The latest date available as a value is not necessarily today or yesterday as it could be mentioned in the dashboard filters. The need is for the dashboard filter is to select the latest date available in the dimension. 

Note: This used to be available on Sisense for windows. 

How do you solve it ? 

1 REPLY 1

harikm007
13 - Data Warehouse
13 - Data Warehouse

@analytik ,

Check if this works for you:

  • Edit you date filter and select Ranking
  • Select Top = 1, 'Days' from dropdown and update the 'Ranked by' formula to MAX([Days in Date])

max date filter.jpg

max date formula.jpg

 

An alternative solution is in below article:

https://support.sisense.com/kb/en/article/calculating-values-for-the-most-recent-date

 

Thanks

-Hari