Recently, Tableau 10.5 was released by Tableau with Hyper technology (which Tableau says it will extract data faster and enhance query performance) and viz in tooltip which is something really exciting.
How to add viz to tooltip in Tableau:
Lets consider superstore data source for this example and import the same file into Tableau
Step 1: Create your main sheet of visualization:
For the first worksheet, we will create state wise distribution with Parameter of Sales and Profit. I have created an calculated field called option using following calculation:
Post this step I created following sheet:
Step 2: Create the visualization that you would like to see in tooltip:
Now we will create an new sheet with visualization which we would like to see when we hover over states in the main sheet. Lets say I would like to see month wise sales/profit, category wise sales/profit and top 5 sub-category sales/profit in the tooltip. Below images for reference of month wise sales:
Step 3: Add the visualization sheets into the main visualization:
Now lets go back to main visualization and add the tooltip viz into main sheet. Normally, we click on tooltip and add textual stuff or dynamic text over there to see on hover. For this, we will add the secondary sheets into tooltip as shown below:
I modified to add 2 more dashboards and it looked like this:
After adding the required tooltip viz, now if we hover over state (I did on New York) we will see the tooltip viz of month wise sales/profit, category wise sales/profit and top 5 sub-categories:
Additionally if you want to modify the height or width of tooltip it can be easily done by changing the maxwidth or maxheight of tableau added tooltip viz (eg: <Sheet name=”Monthwise” maxwidth=”470″ maxheight=”100″ filter=”<All Fields>”> )
Finally, data will be seen in one single dashboard rather going into different sheets or creating different dashboard to display numbers. Final dashboard which I created is shared below:
Do let me know your feedback or if you have any queries.
Thanks!!!