Splunk Search

How to color code one column based on another (Dynamic)column when using chart command?

New Member

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:
alt text

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.

alt text

How can I do this?

0 Karma