Swap Tableau Worksheets with Dynamic Zone Visibility
Вставка
- Опубліковано 8 лип 2024
- Connect with us:
• Upcoming Tableau Classes: www.eventbrite.com/o/onenumbe...
• Subscribe to the OneNumber Newsletter: onenumber.biz/newsletter
• Follow Ollie Linley on LinkedIn: / oliverlinley
Description:
Dynamic Zone Visibility allows us to switch between multiple connected elements on a dashboard, from single worksheets, to multiple worksheets; from a certain set of parameters to another; or from one worksheet with its legends, filters, and parameters, to another.
Dynamic Zone Visibility relies on Boolean fields to work. These simple fields allow Tableau to use TRUE/FALSE logic to determine what to display and when. By using a parameter tied to a Boolean field, we can give our end users the power to select which view to display.
What do you need to make Dynamic Zone visibility work? Here’s my checklist:
1. A parameter that allows you to select different between the various options to display in your dashboard.
2. Boolean calculated fields connected to the parameter.
3. A container in your dashboard containing the worksheets/elements that you want to swap.
In this week’s video, I’ll walk you through how to do a basic worksheet swap using Dynamic Zone Visibility!
Resources:
• Download the Tableau Public Workbook here: public.tableau.com/views/Dyna...
Need help using Dynamic Zone Visibility in Tableau? Schedule an hour with Ollie! www.eventbrite.com/e/tableau-office-hours-with-ollie-linley-eastern-time-tickets-439769641837
Ready to master Tableau? Check out our lineup of upcoming classes! www.eventbrite.com/o/onenumber-15678294163
Great new feature - I see myself going back and updating prior Vis - excellent demonstration Ollie
We are so glad to hear that, thanks Richard! That's exciting that this will help you.
Very neat explanation..much needed
We are glad to hear that, thank you!
Amazing thanks for sharing
You are welcome, we're glad you enjoyed it!
Thanks for the video. Is it possible to swap sheets based on measure value without user intervention?
You're asking: if my measure is above X, then show this chart; if it's below X, show another chart?
Thanks for the video, do you know of any work around for mapping a link for multiple urls but when we click on one link after other it should open in a new window, basically if I have a Dashboard and i have multiple links on it, if i click on one link and then I click on another link it’s opening another link on the same page as the previous link, please let me know of any workaround for this one, Thanks 😊
Thank you! We just answered your question in the "Display Dimension Across Multiple Columns" video
can you make a tutorial how to use a button to change sheet for example bar to line
Hey Ridarsh - good question! You could create two views and use DZV to switch between them! One view with bars and another with lines ☺️
can you make a another parameter that will showcase all the charts
You could probably put an "All" option in the parameter and then the individual calcs would be like:
[Parameter] = "All" OR [Parameter] = "Worksheet A"
It might be pretty cramped with several worksheets showing at once however. Good luck!
@@onenumbertableauThank you! I will check it out.