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–