Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello All,
Below is my bar chart:
This the expression I use : =SUM(QA1)/Count(QA1)
Can I show the total average in same bar chart?
Many Thanks,
Hasvine
Check the attached:
Total Average of the three bars?
May be add a reference line with this expression:
Avg(TOTAL Aggr(SUM(QA1)/Count(QA1), DimensionNameHere))
Hi Sunny,
Does not work,
I need just 1 more bar to chow me the total average but it keeps on giving me a bar for each dimension.
Many Thanks,
Hasvine
I understand what you want, can you share raw data to show you how it can work
Hi Sunny,
Attached is the QVW.
It is frustrating 😄
Many Thanks,
Hasvine
Check the attached:
You are simply the best.. 😄
Many many Thanks,
Hasvine