Splunk Search

How to color columns based on a variable?

New Member

I am charting a Product ID v/s count in a column chart
I want to color the columns in red and green. Red if the PID is X and green if PID is NOT_X
I dont want X and NOT_X to show on the axis or legend.
Is there a conditional chart statement that I can use?

0 Karma

Splunk Employee
Splunk Employee

Have you taken a look at the Splunk 6.x Dashboard examples app, available on Splunkbase?

https://splunkbase.splunk.com/app/1603/

This is a great app for learning how to do different types of visualizations.

alt text

For each example, you can see the XML for the dashboard, as well as any javascript or css that is required for that example.

0 Karma

New Member

I am unable to access the URL

0 Karma

Splunk Employee
Splunk Employee

Try it now. Or go to splunkbase.com and search for dashboard examples.

0 Karma

New Member

I could access it but somehow I am not sure it answers my question.....I want to color the graph based on another variable settings......almost like an if loop for the chart

0 Karma

Revered Legend

What is your search?

0 Karma

New Member

| eval LDOS = case(ldos<0,"PID_LDOS",(ldos>0 OR ldos=0),"PID_NOT_LDOS") | search LDOS=X| chart values(SR) over itemShipped
0


column
{"values(SR)":0x73A550}

When the search is X I want the chart to show Red
When the search is "NOT_X" I want the chart to show green....I am plotting value(SR) and itemShipped.
I could not access the URL mentioned above

0 Karma
State of Splunk Careers

Access the Splunk Careers Report to see real data that shows how Splunk mastery increases your value and job satisfaction.

Find out what your skills are worth!