How to Set Default Date to Most Recent Date on a Filter in Tableau

In this silent video you’ll learn how to filter the view to always show data for the most recent date in the data set in Tableau.

- - - - - - - - - - - - - -

Using specific calculated fields, you can filter the view to show the most recent date. For example, if we wanted to know what when the last Order Date occurred in the Superstore Sample data source; the following calculated fields could be used:

+ Option 1
[Order Date] = {FIXED : MAX([Order Date])}

+ Or, Option 2
IF MAX([Order Date])=WINDOW_MAX(MAX([Order Date]))
THEN 'Max Date'
ELSE 'Other'
END
Please note that both the above calculations will need to be placed in the Filter card and set to True or Max Date (using the above examples)

Related solutions:
- - - - - - - - - - - - - -