4 Replies Latest reply on Dec 17, 2015 8:30 PM by user19752

    adding mean to 2nd Y axis in chart


      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–