Rick ,  Kindly let me know whether this can be achieved , when % is 0 to 90 then green  when  %  is  90 to 95  then yellow when  % is 95 to 100  then red      ... View more

It worked PickleRick . Thank you . ... View more

NonCompliance9x is the field not populating and hence i am not getting the  o/p expected . My code is as below , | savedsearch Saved_Search | eval total_count=Compliant+NonCompliant | eval Compliancepercent=round(100*'Compliant'/total_count,2) | eval Noncompliancepercent=round(100*'NonCompliant'/total_count,2) | eval NonCompliance9x=if(Noncompliancepercent>90 and Noncompliancepercent<95,Noncompliancepercent,null()) | eval NonComplianceRest=if(Noncompliancepercent<90 or Noncompliancepercent>95,Noncompliancepercent,null()) | table trmsc Compliancepercent NonCompliance9x NonComplianceRest ... View more

Thank you Rick, the new color just applies on NonCompliant % but there is no change in chart for values between 90 to 95 . Please let me know whether any thing can be altered.   ... View more

Thank you Jagani . But this didnt give any change to by chart . i tried like  | eval yellowCount=case('Non Compliance %' < 10.00 AND 'Non Compliance %' >5.00,yellowCount."Yellow",true(),yellowCount) |stats count by trmsc "Compliance %" "Non Compliance %" yellowCount |fields - sort_field Compliant NonCompliant total_count count Please suggest me a way .         ... View more