traffic lights for KPIs RRS feed

  • Question

  • Hi all,

    I'm trying to construct a KPI, with the traffic light as status indicator.

    what I would like  to achieve is to display
    - red between 0 and 10%
    - green between 10 and 25 %
    - red again for over 25%

    it sounds quite simple, but I couldn't  figure out how to do that in KPI designer, or in Dashboard. it has to follow the order green - red, or red-green, or green-yellow-red, or red-yellow-green.
    how would you do  a red-green-red?

    thanks in advance.


    PAS 6.3.2217
    PDS 6.3.2214

    Friday, February 27, 2009 1:01 PM


  • Hi Paul,

    You could build a case statement in BIDS – here is an example ‘Gross Margin KPI’ which is part of the ProClarity demo cube:


    Status expression:


    WHEN KPIVALUE("Gross Margin KPI") > KPIGOAL("Gross Margin KPI") THEN 1

    WHEN KPIVALUE("Gross Margin KPI") > (KPIGOAL("Gross Margin KPI") * .9) THEN 0

    ELSE -1



    So in your case you could specify 10-25 as 1 and else as -1

    Microsoft ProClarity | This posting is provided "AS IS" with no warranties, and confers no rights.
    Wednesday, March 4, 2009 4:13 PM