Explore Courses Blog Tutorials Interview Questions
0 votes
in BI by (47.2k points)

There is a live worksheet called Person with columns - Names & Birthdays. We need to create a quick filter with a default value pointing to the latest birthday.

For example: If there are 3 Records as follows,

Names Birthdays

A 8/9/1993

S 6/5/1994

Z 8/15/2000

The filter should hold the default value 8/15/2000 in it with other values unchecked in the drop-down list. 

1 Answer

0 votes
by (17.6k points)

When you add your filter click the little drop-down arrow in the filter --> edit filter-->select the tab labeled "Top"--> by field radio button==>Top from the first drop down-->enter 1 in the next field which will say by after it-->select birthday from the next dropdown--then maximum. This will change the view to show only the most recent birthdate. 

Further, enroll for an online training course to clear the Tableau Desktop Specialist Certification exam. I would recommend this Tableau Course online by Intellipaat.

Browse Categories