1 of 1 people found this helpful
Michael - Here is my best guess at what you are trying to do... each country in the dataset has a value indicating the country with greatest supply. The tooltip shows that country's name, the percent they provide, and the total provided by all other countries in the dataset. Colors are encoded based on country with greatest supply as hue and lightness based on percent that they supply (80%+ the darkest).
I did a bit of processing in Excel to make this because I don't have a great trick for finding max across multiple columns and then identifying the column name associated with the value. You might be able to do that easily in Tableau if you pivot your data though...I just figured that I would work with the data as given.
Workbook attached with the result.
Thank you. This is exactly what I needed.
I have a follow-up question. I am trying to replicate your results with a different set of data I have, but I can't seem to have the two color dimensions co-exist. Could you tell me what I'm doing wrong, and how I can have both the "countrymax" and "max percentage bin" both show up in the results?
Thank you again.
You should be able to add both of them to the viz, and set to color. I do this by adding my first dimension to color, then dropping the second on detail - and then changing it to color (just click on the detail symbol right next to the pill name and change to color).
Here is the official Tableau help info as well: Example – Multiple Fields on Color