Issues with plotting Traffic Signals using the Gauge chart

[Anonymous]

I need help to plot a Gauge Chart using Traffic lights.

I have to display Red, Amber or Green based on the number of Services missing Threshold SLA.

Red - if more than 2 services miss Threshold

Green - if no service misses Threshold

Amber - if 1 or 2 services miss Threshold

Threshold values are present in the field [Theshold numeric] .

CUSTOMER_IMPACT_MINS - outage mins

MINS_IN_MON - total system available mins

Hence System availability = 1 - (CUSTOMER_IMPACT_MINS /MINS_IN_MON )

I have generated a table showing SLA availability for every service. The moment a service crosses a threshold the Traffic light colour needs to change.

Attaching my QV file. Can anybody please help as I dont know what expression to enter.. I used the below expression but it shows an error

if(1- (sum(CUSTOMER_IMPACT_MINS)/sum(MINS_IN_MON))<=[Theshold numeric],
count(Aggr(1- (sum(CUSTOMER_IMPACT_MINS)/sum(MINS_IN_MON))<=[Theshold numeric],[Service Name])))