Gauge chart - Traffic lights

[Anonymous]

Hi

I need to keep the traffic lights RAG status independent of the selection in the multi list box.

Traffic lights need to show Red more than 2 services miss SLA, amber if 1 service misses SLA and green if no service misses SLA

Attaching is my file. I have used set analysis to make it independent of the Business Area, Application and Month but the RAG status still changes on selection of the values in the filter.

Can anybody please assist?

[mayankraoka]

Remove 1 from ur expression as shown below:

count(aggr(if(1- (sum({<PERIOD_NAME=,[Business Area]=,Application=>}CUSTOMER_IMPACT_MINS)/sum({1<PERIOD_NAME=,[Business Area]=,Application=>}MINS_IN_MON))<=Only({1<PERIOD_NAME=,[Business Area]=,Application=>}[Theshold numeric]),[Service Id]),[Service Name]))

Regards,

Mayank

[Anonymous]

Doesnt work with the removal of 1