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.