Total of barchart

[#1]

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

[sunny_talwar]

Total Average of the three bars?

May be add a reference line with this expression:

Avg(TOTAL Aggr(SUM(QA1)/Count(QA1), DimensionNameHere))

[#3]

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

[sunny_talwar]

I understand what you want, can you share raw data to show you how it can work

[#5]

Hi Sunny,

Attached is the QVW.

It is frustrating 😄

Many Thanks,

Hasvine

[sunny_talwar · Accepted solution]

Check the attached:

[#7]

You are simply the best.. 😄

Many many Thanks,

Hasvine