I have 700 sites, I am running a chart command to get some value for each site per day.
| bin span=1d _time
| eval _time=strftime(_time,"%Y-%m-%d")
| chart avg(<somefieldname>) as Value by Site,_time
Output looks like this:
Now I want to color my field values based on the delta between Field1 and rest values in the row. eg. If delta between -35 and -44 is 9 then -44 will be colored yellow. So the ranges are , Delta <=5 - No color ; 5>Delta<=10 - Yellow ; Delta>10 - Red.
How can I do this?