By: Oliver Linley
Ollie lives in Cape Town, South Africa, and is passionate about all things data - and all things Tableau! If you have a question, feel free to reach out to him directly via email.
Does your data set have multiple date fields? For instance, maybe you have both an "Order Date" and a "Delivery Date". Or maybe you have both a "Hire Date" and a "Termination Date".
Sometimes, you need to filter on both date fields at once to answer questions like, "How many people were hired and how many people were terminated in the Marketing Department this year?"
The challenge is, if you filter a worksheet on Year of Hire Date = 2023, you can't see information about people who were hired in 2022 and earlier but terminated in 2023. If you filter the worksheet on Year of Termination Date = 2023, you can see all the details for who was terminated in 2023, but you wont see info for people that were hired and not terminated in 2023.
In this tutorial, we’re going to build a parameter to adjust two date-based filters simultaneously!
All we need to do to make this work is to:
Set up a parameter that contains our date range options
Display the parameter
Create calculated fields that return values when the parameter criteria is TRUE
Place these calculated fields in the view!
For a full walkthrough, check out this week’s video!
Want to supercharge your Tableau learning? Join us for one of our upcoming Tableau training sessions! You can see our summer lineup here!
Resources
Want to keep learning foundational skills in Tableau? Sign up for our weekly newsletter so you never miss new blog posts, videos and events!