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!
One of my favorite and most-often used date filters in Tableau is a range of dates with dynamic start and end dates.
For example, you choose a range of dates (last 7 days, last 14 days, last 30 days, etc.) and then create dynamic start and end date filters that meet that criteria. This is a great way to provide a pre-selected filter range for your users but still give them ultimate control over the exact date range they want to see.
Want to learn how to build on of these? You need a few key ingredients:
Start and end date parameters
Calculations to return dynamic start and end date values
Calculation to filter down to the desired date range
Check out this video for a full rundown on how to set up one of these dynamic date range filters!
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:
Other Date Filtering Videos
Want to keep learning foundational skills in Tableau? Sign up for our weekly newsletter so you never miss new blog posts, videos and events!