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

# Different KPIs rules for a same dimension (Conditional KPI)

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é

• ###### 1. Re: Different KPIs rules for a same dimension (Conditional KPI)

Hi Jose,

Just as a starter but to be complete all possible scenario's should be described.

KPI Var Pto:

IF [Var % Pto]>0 THEN "Green"

ELSEIF [Var % Pto]=0 THEN "Amarillo"

ELSEIF [Var % Pto]<0 and attr([Concepto])<>"BAJAS" THEN "Red"

ELSEIF [Var % Pto]<0 and attr([Concepto])="BAJAS" THEN "Green"

END

So let me know what should happen when attr([Concepto])="BAJAS" and  [Var % Pto]=0 or  [Var % Pto]>0....

Regards,

Norbert

• ###### 2. Re: Different KPIs rules for a same dimension (Conditional KPI)

Hi Norbert!

Thank you very much! you are a genius!

It works perfectly.

I did the following

IF [Var % Pto]>0 AND ATTR([Concepto])<>'BAJAS' THEN "Green"

ELSEIF  [Var % Pto]>0 AND ATTR([Concepto])='BAJAS' THEN "Red Bajas"

ELSEIF [Var % Pto]=0 THEN "Yellow"

ELSEIF [Var % Pto]<0 AND ATTR([Concepto])<>'BAJAS' THEN "Red"

ELSEIF [Var % Pto]<0 AND ATTR([Concepto])='BAJAS' THEN "Green Bajas"

END

Many Thanks

José

• ###### 3. Re: Different KPIs rules for a same dimension (Conditional KPI)

Jose,

Nah....there are more "genius" resources on the block here;) The first one is you... by asking for assistance.:)

Glad i could help out. Thanks for the "Badge":) Appreciated.

Have an nice one.

Regards,

Norbert