Splunk Search

Color table on the basis of their values visualization

ssaini5
Explorer

Hello, 

I am generating the following table in splunk dashboard using the following query from raw data file: 

Two types of values each Process status can have 

Process NameProcess Status
VM_NAME
Process
oracle
cm
server
"vm1 "
"Process1"
"0"
"0"
"0"
VM_NAME
Process
oracle
cm
server
"vm2 "
"Process1"
"43"
"1"
"2"

 

index="log" source="/var/tmp/logs/test.log" | rex max_match=0 (?s)(?<vm>.*?); | mvexpand vm | rex field=vm max_match=0 (?<name>\S+?):?\s(?<value>.*) | rex mode=sed field=value s/(.*)/\"\1\"/g | eval tmp=mvzip(name,value,"=") | rename tmp as _raw | kv | table name value | rename name as "Process Name" | rename value as "Process Status"

Now, I want to color code the values of this table as red/green on the basis of if the running processes are zero or not. I don't want anything complex just a simple color coding would work. Please suggest.

Thanks in advance 

Labels (3)
0 Karma

richgalloway
SplunkTrust
SplunkTrust

Edit the dashboard and click on the pen icon in the heading of the table column you wish to color.  Select the Color tab then choose "Values" from the drop-down menu.  Select "Define rules" then create a rule to paint the cells a certain color if the value is zero and another rule to paint the cells a different color otherwise.  Save the dashboard.

---
If this reply helps you, Karma would be appreciated.
Get Updates on the Splunk Community!

Upcoming Webinar: Unmasking Insider Threats with Slunk Enterprise Security’s UEBA

Join us on Wed, Dec 10. at 10AM PST / 1PM EST for a live webinar and demo with Splunk experts! Discover how ...

.conf25 technical session recap of Observability for Gen AI: Monitoring LLM ...

If you’re unfamiliar, .conf is Splunk’s premier event where the Splunk community, customers, partners, and ...

A Season of Skills: New Splunk Courses to Light Up Your Learning Journey

There’s something special about this time of year—maybe it’s the glow of the holidays, maybe it’s the ...