26 Replies Latest reply: Jun 17, 2015 2:15 AM by Phaneendra Kunche RSS

    Conditional Coloring

      Hi guys,

       

      I've been trying to do some searching for conditional expressions, but I haven't had any luck so far.

       

      Right now I have two KPIs. One that shows Revenue from 2014 and one from 2015.

       

      I did set analysis to filter the revenue by the year:

       

      2014 Revenue Expression: Sum({$<Year={"FY14"}>}"Revenue")

      2015 Revenue Expression: Sum({$<Year={"FY15"}>}"Revenue")


      Now, I would like the 2015 Revenue to be a certain color depending on if it's higher or lower than 2014 Revenue (example: red if lower, green if higher).


      I checked conditional coloring, but I'm a little confused as to how the expression should be formatted (most likely an if expression?).


      Any help would be greatly appreciated. Thanks!