Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
You just need to add another expression with avg([Dimension]) and uncheck bar and check values on data points. I have attached an example.
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
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.