How to Filter Multiple Date Fields at Once in Tableau

🔔 Book a FREE 15-min Tableau call here: https://forms.gle/DfW6TJkMjsmBytig8

Connect with us:
•Upcoming Tableau Classes: https://www.eventbrite.com/o/onenumbe...
•Book an hour to work with Ollie: https://www.eventbrite.com/e/tableau-...
•Subscribe to the OneNumber Newsletter: https://onenumber.biz/newsletter
•Follow Ollie Linley on LinkedIn:   / oliverlinley  

Description:
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: https://www.eventbrite.com/o/onenumbe...

Resources:
•Example Tableau Workbook: https://public.tableau.com/views/Filt...
•How to Build a Custom Date Filter for a Tableau Dashboard: https://onenumber.biz/blog-1/2022/1/2...
•Build a Selected vs. Comparison Date Period Filter in Tableau: https://onenumber.biz/blog-1/2022/3/2...

Chapters:
0:00 Intro to Example
3:28 Building Solution