Dynamic Start and End Date Filter in Tableau
Вставка
- Опубліковано 15 жов 2024
- 🔔 Book a FREE 15-min Tableau call here: forms.gle/DfW6...
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!
Resources:
•Walk Along Tableau Workbook: public.tableau...
•Complete Tableau Workbook: onenumber.biz/...
•Layout Containers: onenumber.biz/...
•Business Dashboard Formatting: onenumber.biz/...
•Dynamic Parameters in Tableau: onenumber.biz/...
•Calculate and Filter to MAX Date in Dataset: onenumber.biz/...
Other Date Filtering Videos:
•Dynamic Date Filter in Tableau: onenumber.biz/...
•Custom Date Filter in Tableau: onenumber.biz/...
•Build Selected vs. Comparison Date Period Filter in Tableau: onenumber.biz/...
Connect with us:
•Upcoming Tableau Classes: onenumber.biz/...
•Book an Office Hour with Eric: www.eventbrite...
•Subscribe to the OneNumber Newsletter: onenumber.biz/...
•Follow Eric on LinkedIn: / eric-parker-37513249
Need help with Tableau? Schedule an hour with Eric here: onenumber.biz/office-hours
Ready to master Tableau? Check out our lineup of upcoming classes! onenumber.biz/onenumber-tableau-classes
Very helpful. Thank you
Glad to hear it, you are welcome!
Thank you for your video, this was really helpful! I had a question -- If I had a dashboard with a bunch of different fields and wanted to filter all of them based on the start and end date filter, how would I do that? And is there a way I can use this start and end date filter as a slider and have that filter all the data on the dashboard?
Hi, thanks for checking this video out! There should be some concepts in this video which should help you: onenumber.biz/blog-1/2023/6/7/how-to-filter-multiple-date-fields-at-once-in-tableau
Great video! You are talking very awake and exciting!