1 Reply Latest reply: Apr 15, 2018 9:33 PM by Rachel Delany RSS

    Setting different color threshold for Climber KPI

    Priyaranjan Pattnayak

      Currently, I am using 3 different color banding based on the relative comparison of actual and target measure.

       

      Is there a way I can set different threshold for banding based on different values of actual measure?

      For example:

      Actual Measure = sum(sales) aggregated over a day

      Target Measure = average daily sales calculated over a month.

       

      If Actual Measure > 80:

      Actual - Target > 10 => green

      Actual - Target < 10 => red

      else yellow

       

      Similarly,

      If Actual Measure > 90:

      Actual - Target > 5 => green

      Actual - Target < 11 => red

      else yellow

       

      Can I implement this logic in my color bands?