Hello everyone,
I'm trying to create a what-if heat map - Its a lot more difficult than it seems.
Its a simple calculation of a productivity ratio based on the number of cases completed per hour.
The values within the heatmap is the number of hours required.
Does anyone have any ideas? Thank you.
Hi Amer,
Its possible with the conditional formatting in Tableau. Please check the following KB article, video and let me know if that helps you.
http://kb.tableau.com/articles/howto/conditional-format-row-background-color
Tableau: Advanced Conditional Formatting - YouTube
Thanks
Madhu K
Madhu,
Thank you for the response but my issue has to do with the calculations- I am familiar with conditional formatting. I think I was unclear.
In the example above, I have 1080 cases on average and a productivity rate of 2.3 on average. These are the results of my AVG calcs in tableau.
I'd like to expand them in increments of, lets say 10% for each row/column, then display the calculated hours required.
From there I can apply formatting.
Amer