AnsweredAssumed Answered

adding mean to 2nd Y axis in chart

Question asked by rubinjm on Dec 14, 2015
Latest reply on Dec 17, 2015 by user19752

I am trying to add a 2nd Y-axis to show the mean for a group of values.

 

In the attached example, I am trying to add the average of the weekly count to the plot of the counts by week.

 

the field named Mean Count is a summary field = average of count

 

When I add the 2nd Y-axis and specify the Mean Count field, it displays the same values as count.

 

What I want is to just have a horizontal line at 150.2 that crosses all weeks to show the overall mean.

 

I have a set of 5 charts that I'm creating. I was able to get this to work on 1 of them but not the rest. I can't figure out why it works on that one and not the others.

 

Thanks for any help–

Outcomes