Need help setting up your worksheet swap? Schedule an hour with Eric here: www.eventbrite.com/e/tableau-office-hours-with-eric-parker-tickets-42691995909 Ready to master Tableau? Check out our lineup of upcoming classes! www.eventbrite.com/o/onenumber-15678294163
thank you so much. So many RU-vid videos out there on this subject and I didn't realize the older vids were out of date. Tearing my hair out following the steps of those videos exactly but then my screen wasn't doing what theirs was. So frustrating, and so relieved to watch your video about adding the formula. Woohoo!
Hi Eric. Thanks for calling out the Tableau issue affecting sheet swapping in v2022.2. In great tableau tradition of being able to achieve the same outcome several ways, there is a slightly shorter method which does not require the condition for activating sheet swapping. At 4:12 in your video, instead of going to 'Condition', go to General > 'Custom Value List > 'Enter Text to Search or Add'. on each sheet, enter the valid parameter entry; Map for sheet 1, Bars for sheet 2 and , Dot Plot for sheet 3. Select [+] on each sheet to add the relevant string.
You are the best!! I've searched the whole internet trying to understand why my Tableau didn't hide the other options. Thanks a lot man!! You have made 1 person very happy today : X
I'd used this method before to enable flipping back and forth of worksheets on my dashboards but had no clue this update changed the way to do that. This is so helpful, thanks so much!
Spent longer today than I'd care to admit, trying to figure out what on Earth I was doing wrong--the traditional parameter/swap methodology all of a sudden wasn't working anymore. Totally v2022.2. Ugh. Thanks so much for the walk-through, Eric!
Thsnk you so much for that video!! Amazing videos, easy to understand, easy to remember! You are not just experts in tableau, you also are amazing teachers! Well done, and thank you for that channel.
Nice, thanks! I noticed for these options Map, Bars, and Dot Plot you chose "Worksheet Selection Filter" for Maps and "Worksheet Selection Parameter" for Bars, and "Worksheet Selection Filter" for Dot Plot. Why not the same for all three? Thanks
Thanks so much Eric! After spending several hours trying to figure out why I could no longer swap sheets (using the same method I've used for a few years now) your video solved the issue. Kind of irritating Tableau made the change (although I'm assuming they had a good reason ... or maybe not the way things at Tableau seem to be headed) without somehow making it more obvious to users how the change would impact their dashboards. Can't thank you enough for this one!
Great video! on the last step my two sheets in the container don't resize...it just has one half or the other go blank--is there a way to tell it to auto-resize?
Hi and great timing! Check out this video we just put out and ensure none of your objects are fixed height: ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-hPPgXTCzCM8.html&ab_channel=OneNumber-TableauExperts
You're welcome! You can, here's a blog post on it: onenumber.biz/blog-1/2020/1/22/creating-dynamic-color-legends-for-worksheet-swaps You might find it easier to use Dynamic Zone Visibility to swap numerous objects though: onenumber.biz/blog-1/2022/3/29/tableau-dynamic-zone-visibility
Not with this approach but it might be worth trying a worksheet swap with Dynamic Zone Visibility instead. How to here: ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-EkKgPs9ky4k.html&ab_channel=OneNumber-TableauExperts
Thank you. The video is really helpful. I tried to implement same thing in my dashboard. But I am facing a different issue. I also have legend in my sheets. And when swapping sheets either both legends are present in both sheets or single one for both sheets which is not what I want. Can you help me with it?
Hey Keval, 2 options for you: 1. Get the legend to swap as well by tying it to a 3rd sheet: onenumber.biz/blog-1/2020/1/22/creating-dynamic-color-legends-for-worksheet-swaps 2. Use Dynamic Zone Visibility to swap and it an swap legends, filters, parameters too : onenumber.biz/blog-1/2022/3/29/tableau-dynamic-zone-visibility
@@onenumbertableau Thank you for the help. I tried implementing the Dynamic Zone Visibility Method but I cannot find it in my dashboard. Could you please let me know what should be the minimum Tableau version for getting that feature? Also, can it be directly applied to a sheet or it must be applied to containers? Hoping for your reply soon.
Great video! Working great for most of my objects except one. I have a table with 4 columns (KPI indicators) and it will display which ever table is listed higher in the item hierarchy layout but will just show a blank space when the one listed lower in the hierarchy is selected. This issue does not happen with my 3 other charts (2 line charts and 1 data table). Any ideas?
I'm guessing one of the objects in your container has a "fixed height". Click in the background of the sheet, and you'll see a little white pin the top right corner of that sheet. Deselect that white pin so it has a hollow middle. It is now a "dynamic height" object. Hopefully that does it!
@@onenumbertableau I am trying to do the same. Everyone shows how to make it work for 3 graphs . But it doesn't with 4 or more graphs. Tableau automatically ''fixed height'' for 4th container
@@denyskyrianov1701 Weird. I had never had that issue before but just tried to create a swap with 4 sheets and experienced the same issue you mentioned. I'm guessing this also has something to do with updates Tableau has made but I'm not sure what specifically. I think worksheet swaps with Dynamic Zone Visibility might be the best bet for 4+ worksheets: onenumber.biz/blog-1/2022/3/29/tableau-dynamic-zone-visibility
I suppose if you gloated a layout container and the objects were tiled inside the floating container, yes. However, Dynamic Zone Visibility is probably a better fit for swapping floating objects: onenumber.biz/blog-1/2022/3/29/tableau-dynamic-zone-visibility
Hi Eric, in 4:14 you've entered [Worksheet Selection Filter] for Map but in 5:03 you've entered [Worksheet Selection Parameter] for Bars. Then for Dot Plot, you've entered [Worksheet Selection Filter] again. May I know why is Bar's condition different from the rest? It seems that the swapping still work for all of them despite the different conditions.
Hi! Thanks for checking our video out. No real reason other than I accidentally referenced the parameter. I meant to reference the calculation all 3 times.
Make sure that the little "Fix Height" pins on the worksheets in the layout containers are not selected. If the objects have been manually adjusted at all they are likely Fixed Height and then won't expand and Contract accordingly. If you're not sure what I'm talking about jump to around 5:20 in this video: ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-lG6HgkaKwTU.html&ab_channel=OneNumber-TableauExperts
When i choose to show color legend for each worksheet, there is always a blank row when i swap among worksheets. Is there a way to hide the color legend from other worksheets when showing one worksheet?
Your best bet is to tie the color legend/filters to a worksheet that isn't swapping. Check out this post on the topic: onenumber.biz/blog-1/2020/1/22/creating-dynamic-color-legends-for-worksheet-swaps
Are your filters applied to both sheets? (More info on how to do that here: ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-mq32Ln-2cNg.html&ab_channel=OneNumber-TableauExperts)
This is such a good question. I made a note to myself to make a follow-up video on this topic. No, unfortunately other objects like Filters, Legends and Parameters can't be easily swapped this same way. I recommend creating a third worksheet which doesn't change which things like Color Legends and Filters are connected to because a filter or color legend attached to a disappearing/collapsed sheet will display only null values. Here's a blog post about how to make dynamic color legends. This process should work for filters too onenumber.biz/blog-1/2020/1/22/creating-dynamic-color-legends-for-worksheet-swaps