how to show the Avg of all the sections as data point on a stacked bar chart
Requirement: I have to show Average lead time for each team and region. So Team is my primary dimension and Region my second which will create the sections in the bar. and appear as legends.
Now for example, Team A has a avg lead time 2 days for all the 5 different regions. The value on top of the stacked bar would be 10 but I want it do be 2 i.e Avg rather than the sum of avg lead time for each region.
Re: how to show the Avg of all the sections as data point on a stacked bar chart
I figured out a workaround but it is not ideal. I have a separate bar chart (not stacked) that displays the average with invisible bars. and on top I have the stacked bar chart with invisible dimension font. They must be lined up just right. Hopefully you can get that to work with your data.