2 Replies Latest reply on Jun 27, 2016 12:50 PM by charles.dickson

    Creating Reference Lines

    charles.dickson

      Hello,

       

      I have created to line charts showing what is coming in and the other showing what is going out. I have two different date fields for these but I have synchronized it into one chart. I am trying to add a reference line which will give me an average for the measure for the two date fields. I will also like to add a historical average which also be dynamic to any filter when I used it on a dashboard. For example, I will like to see two average lines for the current year and two average lines for the previous year.

      I know this is confusing but I have attached a sheet that shows what I am trying to do.

       

      Thank you.