10 Replies Latest reply on Jun 9, 2016 11:39 AM by Derrick Austin

    determine the colour of the whole line in a graph with a calc?

    edward.alexogiannopoulos

      Hi everyone -

       

      I really need some help here.

       

      I have a graph that is linked to a filter.

      based on whether the current spend is more or less than a year ago I want the line to be either green or red.

       

      My current attempt at achieving this has failed -

       

      example 1.PNG

       

      I've tried various calcs but nothing is working for me. Any advice would be greatly appreciated.

       

      Many thanks,

       

      Ed.