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

    adding mean to 2nd Y axis in chart

    rubinjm

      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–