Hi Kelly, I have a later version of Tableau, so I can't save and send back your workbook, but I have attached screenshots.
If your real data is as simple as this, I would Pivot it to make it easier to work with. On the Data Tab, select Blue, Purple, Red, and Yellow columns, right click, and select Pivot. I always find measures easier to work with in this format.
This is the result:
You can rename the columns to make them more meaningful:
Now it is easier to work with the data.
1. Put Volume on the Rows shelf, click for the menu, go to Quick Table Calculation, and choose Percent of Total.
2. Put Color on the Color button in the Marks Card.
3. Put Volume on the Tooltip button in the Marks card, so we can add it into tooltips
Your Tooltips show all the values - you can edit it to make the descriptions more friendly.
All the best,
Thank you for the quick reply! Unfortunately I'm pulling the data directly from a table in our database so I cannot pivot the fields.
Ok, wow, that's an interesting problem. If it were me, I would create a view in the database to pivot the data to make it easy to work with in Tableau. I always shape the data as perfectly as possible in the source before bringing to Tableau, if I have control of the source.
But of course that is not always possible, and I am curious to know how to solve this problem. I could figure out how to create the % of Totals for the bar chart, but I could not figure out how to make this work nicely on the Tooltips. I did a little digging and found this article which explains it. I figure it makes more sense to attach the original article than re-explain it myself.
I hope this helps and will look forward to other solutions posted by the community .
1 of 1 people found this helpful
You can write a custom SQL query to get the data in a pivoted form. If you need help with it, let me see your current query so that I can suggest how it can be modified to achieve what you need.