Hello Fellow Tableau users,
I was hoping if I could engage all of your bright minds to help me solve a request. I am trying to create a stacked bar with 3 aggregate of different measures but I want the height of the stacked bar to be equal to aggregate of a completely different measure. Since scrubbing of the whole data set is not a viable option my sample dataset looks like this in excel
and what I am trying to achieve is stacked bars with height of avg T but the color distribution be among avg A,b&C
|Month||avg A||avg B||avg C||avg T|
Any help is deeply appreciated.
Using two sheets and bringing them together on a dashboard with defined axis for each will allow you to achieve a result like this.