Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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,
hi
Use avg(total fieldname)
Hope it helps
HI
Add reference line
In presentation->Reference lines -.add and give expression or 8.75
Hope that helps
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
Hi
Just give 8.75 in expression
Hope it helps
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
hi
Use avg(total fieldname)
Hope it helps
This worked as required .
Thxs