[Update: It is reported the tooltips are not working in 10.4. I tested it in 10.5 and confirmed that it is not working either. Will update if there is a workaround.

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.

The solution is to have one container for every sheet. Then overlay the containers on top of each other. And we use vertical containers.

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!
7

View comments

  1. 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?

    ReplyDelete
    Replies
    1. http://vizdiff.blogspot.com/2016/03/sheet-swapping-with-pie-tree-map.html
      Check out the above addressing packed bubble chart in sheet swapping

      Delete
    2. Thanks, you're a life saver!

      Delete
  2. In 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).

    ReplyDelete
    Replies
    1. Sorry 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.

      Delete
  3. In 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?

    ReplyDelete
  4. This comment has been removed by a blog administrator.

    ReplyDelete

(Refresh the page if you want to view the gif image multiple times. Or go to Tableau Public and click the button at the top-right corner.)

Jake and I collaborated on a dashboard. He told me that he learnt a way to create an in-place help page in Tableau. He first saw it at a conference somewhere and couldn't recall who the speaker was. So I am blogging here about it but the credit goes to somebody else. If anyone knows who the original creator is, leave a comment below.

The key idea is to float a semi transparent worksheet on top of the dashboard, where a help text box is strategically placed on top of each chart. This way, we can explain how to view each chart and what data points are important, etc. This worksheet is collapsible by a show/hide button. 

Below I would like to show how this worksheet can be constructed.

1. Sheet with a single data mark.

  • Double click the empty space in Marks panel and add two single quotes. Make the null pill a text label. This creates a single null mark.
  • Set the view as "Entire View"

2. Create an show/hide button

  • Go to the target dashboard
  • Drag a floating vertical container to the dashboard, making it cover all the area of interest.
  • Drag the Single Null Mark sheet and drop it into the above container. Hide the sheet title.
  • Create an open/close button for the container and place the button at the top-right corner.

3. Add annotations

  • Format the sheet background opacity as 70% in the layout manager             
  • Select area annotations and place them anywhere of interest. 
  • Write help text and format it to highlight important messages.  
  • The text can serve as functional guide and/or insight guide.

Here is an example. Feel free to download the workbook and explore. Click the "i" button at the top-right corner to view the in-place help. 

0

Add a comment

Blog Archive
Loading
Dynamic Views theme. Powered by Blogger. Report Abuse.