Show Avg of expression in a bar chart

[alec1982]

Hi Guys,

I have bar chart that shows scores per quarter of year

Quarter     Score

Q1               7

Q2               9

Q3               10

Q4               9

on the dimenssion I have the Quarter and on expression I have three expressions:

          1. Average score(Bar)= Avg(Score)

          2. Highest Score(Line) = max(Score)

          3. On this Expression, I need a line to show the average of all the scores as a straight line

like on the data provided, the Avg is 8.75 so I need a stright line to go across the chart and reflect this value

Let me know if you can help and thank you so much.

Alec, 

[MayilVahanan]

HI

Add reference line

In presentation->Reference lines -.add and give expression or 8.75

Hope that helps

[alec1982]

Hi,

Thanks for your reply but I am in a need to have it as expression so i can show it in the legend.

Thxs,

Alec

[MayilVahanan]

Hi

Just give 8.75 in expression

Hope it helps

[alec1982]

Hi,

Thank you so much for your help. but in this case it will be a fixed amount while the 8.75 might change to 8 as we add scores to the source document.

Regards,

Alec

[MayilVahanan · Accepted solution]

hi

Use avg(total fieldname)

Hope it helps

[alec1982]

This worked as required .

Thxs