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])))