I wrote a request for bringing the feature back to new Tableau. Please vote it up here
https://community.tableau.com/ideas/9126
]
[Joe Oppelt has figured this out and mentioned this in a forum discussion. At the time, I just didn't understand what he was talking about. I even suggested him to write a post. Much of the credit goes to Joe.]
This is a sequel to Seamless Sheet Swapping and Sheet Swapping with Pie/Tree Map/Packed Bubble Charts with update on interactivity. Sheet swapping used to have a shift problem if multiple sheets are all crammed into a single container. It can be made seamless with no shift by laying sheets on top of each other.
After the publication of the above post, Joe Oppelt, a fellow Tableau Ambassador, pointed out to me that, it has some issues with interactivity like tooltips. Only the tooltips on the top sheet will show if selected. The tooltips on the other sheets underneath will never show.
Joe and Matt Lutton made a highly popular video on sheet swapping. In a video conference session, Joe gracefully showed me some wizardry using horizontal containers plus pop-up sheets to solve the problem, allowing interactivity for all the sheets. You can view and download Joe's demo workbook here. To this day, I still wonder what is the mechanism behind.
Joe also told me that, with his design, we won't see the interactivity in Tableau desktop. It shows only after being published to the server. (What a curious discrepancy between Tableau desktop and server!)
The discussion with Joe led to an alternative solution which seems much simpler. Still it works only on server.
Assume we have 3 sheets that are supposed to be displayed one at a time.
Here are the major steps for creating seamless sheet swapping dashboard with tooltips:
1.Set up the selector as a parameter which is described here
http://kb.tableau.com/articles/knowledgebase/creating-sheet-selector-for-dashboard
In my example, I assigned the parameter values as 1,2,3. The descriptions are Line, Bar and Circle.
2.Create a filter and set it up as described in the above KB article.
3.Drag 3 Vertical Containers (in Floating mode) to the Dashboard canvas. Place them anywhere without overlap.
4.Drag one sheet into each of the containers (in Tiled mode). Make each sheet to be shown in Entire View if you wish.
5.Set x,y,w,h parameters of each vertical container in the layout manager as follows:
We are using an 800x600 canvas. So the containers are of the same size. Note this is a different layout from the one in previous post.
6.Publish the workbook to the server to view the tooltips!
Click the following image to view or download the interactive workbook.
Why vertical containers?
When the sheet inside the vertical container is not selected, the sheet will collapse vertically into a thin line of 13-pixel high. Since there is only one active sheet, we will see the sheet in all its glory. There is no sheet on top of others! Hence all its tooltips are responsive.
A non-selected sheet inside a horizontal container doesn't seem to collapse laterally. It stays open with visual transparency and blocks any sheet underneath from being interactive. That's why vertical containers are a better choice. I found out that we can make the sheet inside a horizontal container collapse by adding a blank object to the same container. It takes a few more steps than the vertical approach. An example is included in the workbook.
In containerless sheet swapping, the non-selected sheets become transparent instead of being collapsed, thus blocking the interactivity with the mouse. Only the top sheet remains sensitive to the mouse.
Note that the workbook includes another dashboard which has the following layout. In this way, it minimizes the collapsed space from 13-pixel to be 9-pixel high.
That's it!
Thanks for this tip, it's working really well for most of my dashboard items. For some reason I haven't been able to get it work with packed bubble charts however. Do you have any idea why that might be?
ReplyDeletehttp://vizdiff.blogspot.com/2016/03/sheet-swapping-with-pie-tree-map.html
DeleteCheck out the above addressing packed bubble chart in sheet swapping
Thanks, you're a life saver!
DeleteIn version 9.3.1 This no longer seems to work - the interaction with lower floating containers is blocked by the upper containers (they don't collapse anymore).
ReplyDeleteSorry to see this now. You need to publish the dashboard to the server to see the effect. The swapping doesn't happen on Desktop. Try again.
DeleteIn v9.3.1 this no longer works properly. The upper floating containers do not collapse and block all interaction with the lower layers. Are there any work arounds?
ReplyDeleteThis comment has been removed by a blog administrator.
ReplyDelete