sorry, i tried but i'm still not getting the result i wanted.
If i use the below, i got separate chart per color as per attached pic.
https://ibb.co/WP28T9K
|myresult
| eval Threshold_Color=case(Error_Count>0 AND Error_Count<=20, "1. Normal", Error_Count>20 AND Error_Count<=30, "2. Warning",Error_Count>50 AND Error_Count<=100, "3. Critical",true(),"4. Severe")
| xyseries errorCode Threshold_Color Error_Count
If i use below, still 1 color for every bar in the column chart. pic 2 attached. It is disregarding my color threshold.
https://ibb.co/9nYR9BY
|myresult
| table errorCode Error_Count
| eval Threshold_Color=case(Error_Count>0 AND Error_Count<=20, "1. Normal", Error_Count>20 AND Error_Count<=30, "2. Warning",Error_Count>50 AND Error_Count<=100, "3. Critical",true(),"4. Severe")
| xyseries errorCode Threshold_Color Error_Count
... View more