In a Sales worksheet, users must interactively pick Today, Year-to-Date, Previous Quarter, or an arbitrary range without you creating separate views. What type of date filter should you add and show to the worksheet to meet this requirement?
Filter using the discrete Date Part (Year) option and display it as a multi-select list.
Create a parameter for the date range and use a context filter referencing that parameter.
Place the continuous date field on Filters, choose Relative Date, and select Show Filter.
Apply a Top N filter on the date field to keep only the most recent dates.
A relative date filter supports multiple pre-built periods such as Today, Yesterday, Year to Date, Previous Quarter, and also lets the user select a Custom range. Displaying this filter to users therefore satisfies all requested scenarios with one filter. A discrete date part filter restricts selection to a single part (for example, just years), a context filter combined with a parameter still needs an additional calculated field, and a Top N filter is designed for ranking, not dates.
Ask Bash
Bash is our AI bot, trained to help you pass your exam. AI Generated Content may display inaccurate information, always double-check anything important.
What is a Relative Date Filter in Tableau?
Open an interactive chat with Bash
Why can’t a discrete date part filter be used for this scenario?
Open an interactive chat with Bash
How does a Top N filter differ from a Relative Date Filter?
Open an interactive chat with Bash
Tableau Desktop Foundations
Exploring and Analyzing Data
Your Score:
Report Issue
Bash, the Crucial Exams Chat Bot
AI Bot
Loading...
Loading...
Loading...
Pass with Confidence.
IT & Cybersecurity Package
You have hit the limits of our free tier, become a Premium Member today for unlimited access.
Military, Healthcare worker, Gov. employee or Teacher? See if you qualify for a Community Discount.
Monthly
$19.99
$19.99/mo
Billed monthly, Cancel any time.
3 Month Pass
$44.99
$14.99/mo
One time purchase of $44.99, Does not auto-renew.
MOST POPULAR
Annual Pass
$119.99
$9.99/mo
One time purchase of $119.99, Does not auto-renew.
BEST DEAL
Lifetime Pass
$189.99
One time purchase, Good for life.
What You Get
All IT & Cybersecurity Package plans include the following perks and exams .