Set the latest date value to the Quick Filter in TABLEAU

Question

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. 

Answer 1

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.