By: Eric Parker
Eric Parker lives in Seattle and has been teaching Tableau and Alteryx since 2014. He's helped thousands of students solve their most pressing problems. If you have a question, feel free to reach out to him directly via email. You can follow him on LinkedIn or sign up for a Tableau Office Hour to work with him directly!
Filtering on a date range in Tableau is pretty straightforward, right? But how about if you want to filter on that date range AND you want a comparison date range filtered at the same time? That's trickier.
For example, you set a filter from January 1st to March 15th 2024 and you want a comparison period of January 1st to March 15th 2023 to automatically be set, how do you do that?
This brew is going to require a few key ingredients:
Start and End Date Parameters for the Selected Period
Start and End Date Calculations for the Comparison Range
T/F Calculations for the Selected and Comparison Ranges
Custom Calculations for the Measures Being Compared
Ready to dive in and learn how all this works? Check out this video!
Need help with Tableau? Sign up for an office hour to work with Eric! You can also check out our upcoming classes for a Tableau deep dive!
Related 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!