3 Replies Latest reply on Apr 22, 2016 2:24 AM by Edward Yeldham

    Graph multiple years and a forecast

    Edward Yeldham



      I have the visualisation as shown in my screen shot,  it simply shows annual cumulative sales value with year on the colour marker.  I would like to add to this graph a line to show the current year forecast as a running total also.


      I have a measure called "Forecast Value" which is shown by my mouse pointer in the attached screen shot.  It is from a different data source but blended in so works fine.  However I can't work out how to get this to display on my graph as a different line?  If i drag to colour I lose my multiple year lines and it shades them according to forecast.


      Do I need a reference line - but these are a bit confusing also!