How to add filter to show latest two dates in tableau

Question

What I want?

Add a filter in Tableau which automatically shows data for last two days. 

What I did?

I tried using Dense rank (which works in SQL) but in Tableau, I can't figure out which aggregator function to use with it.

How can I add the filter to show latest two dates in Tableau?

Answer 1

Steps for filtering based on the most recent dates:

1. Right-click and drag the date field to the filter shelf
2. Select "Individual Dates"
3. From the filter dialog, choose "Top" and "By field"
4. Select "Top", 2 (for the most recent two dates)
5. Select the date field and choose Maximum for aggregation.