Splunk Search

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

achoudhary1
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
Get Updates on the Splunk Community!

Dashboards: Hiding charts while search is being executed and other uses for tokens

There are a couple of features of SimpleXML / Classic dashboards that can be used to enhance the user ...

Splunk Observability Cloud's AI Assistant in Action Series: Explaining Metrics and ...

This is the fourth post in the Splunk Observability Cloud’s AI Assistant in Action series that digs into how ...

Brains, Bytes, and Boston: Learn from the Best at .conf25

When you think of Boston, you might picture colonial charm, world-class universities, or even the crack of a ...