how to show the Avg of all the sections as data point on a stacked bar chart

[pranaview]

Hi All,

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.

Please let me know how can i implement this.

Thanks,
Pranav 

[lockematthewp]

You just need to add another expression with avg([Dimension]) and uncheck bar and check values on data points. I have attached an example.

[pranaview]

Hi, 

thanks for the suggestion but how come the avg time for Team B is coming as 10?

It should be 6, right?

Regards,
Pranav 

[lockematthewp]

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.