Choose the latest date available in a dashboard filter

[analytik]

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 ? 

[harikm007]

@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])

An alternative solution is in below article:

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

Thanks

-Hari