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!