14 Replies Latest reply on May 8, 2018 3:40 PM by Elie Rahi

    Segment Line into 2 Colours

    Elie Rahi

      I need to segment a line in a line plot into two different colours. One colour showing Jan-Apr 2018 actual and another colour showing the forecast May-Dec 2018. I'm unsure how to go about doing this. I tried doing a calculated field:


      IF [Month 1] >= #1/05/2018# THEN "Forecast"

      ELSE "Actual"



      But has not worked out