How to add filter to show latest two dates in tableau?

0 votes

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?

Jun 20, 2018 in Tableau by ghost
• 1,790 points
18 views

1 answer to this question.

Your answer

Your name to display (optional):
Privacy: Your email address will only be used for sending these notifications.
0 votes

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.
answered Jun 20, 2018 by Atul
• 10,200 points

Related Questions In Tableau

0 votes
1 answer

How to add parameter and calculated field filter in tableau?

Hi Sindhu,  You cannot add parameter as a ...READ MORE

answered Mar 8 in Tableau by CHERUKURI
• 13,940 points
44 views
0 votes
1 answer

How can I add legends to worksheet in Tableau?

Just add the worksheet on the dashboard ...READ MORE

answered Apr 20, 2018 in Tableau by Atul
• 5,470 points
72 views
+1 vote
1 answer

How to add grand totals of the bar in Stacked Bar in Tableau

Hi Grim, As you have used reference line ...READ MORE

answered Sep 24, 2018 in Tableau by Machdata
• 340 points
68 views
0 votes
1 answer

How to make two parameters dependent in tableau?

Hi, 2 parameters are dependent when one ...READ MORE

answered Mar 12 in Tableau by CHERUKURI
• 13,940 points
37 views
+1 vote
1 answer
0 votes
1 answer

Calculated filed with if-then

Below is the required code:  IF (NOT ISNULL([test2])) ...READ MORE

answered Mar 27, 2018 in Tableau by Atul
• 10,200 points
36 views
+2 votes
1 answer
0 votes
1 answer

Reset filters in Tableau

I understood your question (I hope so!). ...READ MORE

answered Mar 29, 2018 in Tableau by QueenBee
• 1,810 points
290 views
0 votes
1 answer

How to color code cells of a column based on the text value in Tableau

You can use the following steps to ...READ MORE

answered Mar 27, 2018 in Tableau by Atul
• 10,200 points
945 views
0 votes
1 answer

How to combine rows with same information in Tableau

@Ghost, Tableau has a function RANK_UNIQUE which you ...READ MORE

answered May 24, 2018 in Tableau by Atul
• 10,200 points
363 views

© 2018 Brain4ce Education Solutions Pvt. Ltd. All rights Reserved.
"PMP®","PMI®", "PMI-ACP®" and "PMBOK®" are registered marks of the Project Management Institute, Inc. MongoDB®, Mongo and the leaf logo are the registered trademarks of MongoDB, Inc.