how do I set if condition if the "failurepercentage" is greater than 10 as amber and greater than 20 should be severe.
eval failureStatus=if(failurePercentage < 10,"25",(if(failurePercentage>=3 AND failurePercentage<=10,"15","5"))) |rangemap field=failureStatus Low=0-10 Amber=11-20 Severe=21-30
Hi
It looks like you used field=failureStatus
instead of field=failurePercentage
in rangemap
.