3 Replies Latest reply on Apr 20, 2017 3:32 AM by Norbert Maijoor

    Different KPIs rules for a same dimension (Conditional KPI)

    Jose Silva

      Hi,

       

      I have a table with 3 columns “Real’17”, “Pto’17” and “% Pto” (which is just the column A (Real’17) divided by the column B (Pto’17)

      I would like to show a simple KPI, when % Pto <0 then “Red”, when % Pto >0 then “Green” and when % Pto=0 then “Yellow” (Like the image)

       

      But the problem is that this color code is different when the concept is “BAJAS”, it is to say, the other way around: when % Pto <0 then “Green”, when % Pto >0 then “Red”

       

      How can I set two different KPI rules for a same dimension (Concepto) based on the concept I have?

       

       

      I will be very grateful with any help

       

      Many Thanks,

      José