Hello,
I am trying to create a 100% stacked bar chart. Every post or video I see on how to do this uses the SUM or Count as a the measure being analyzed. I'm trying to do it with the AVG measure and am stumped on how to get it to work correctly. I have tried every variation of "compute using", but still end up with wacky percentages.
The desired result would be to have the percentages show as in blue:
Any help getting to the desired result would be much appreciated. Working in Tableau 2018.3.1 version.
Hi
try this - it totals the actual averages times
then this
determines the %
it returns this
Jim
If this posts assists in resolving the question, please mark it helpful or as the 'correct answer' if it resolves the question. This will help other users find the same answer/resolution. Thank you.
