2 Replies Latest reply on Sep 18, 2015 6:57 AM by Ali Siddiqui

    Show average of measures in scatter plot

    Ali Siddiqui

      I have two levels of a problem:

       

      Level 1:

      I have a basic scatter plot and I want to plot the averages for these measures as well.

       

      Any hints on how to do this? I read some posts about using Dual Axis but I couldn't get it to work for me.

       

      I attached what I have now and what I am trying to achieve. The blue lines in the "desired" picture are made on MS Paint for now

       

      I also attached my underlying data set as an excel doc.

       

      Level 2:

      I would like the averages to dynamically update based on any filters that are applied. Is this possible? If not, then I am good with just using the overall average of the entire data set.