topic Re: How to color columns based on a variable? in Splunk Search

How to color columns based on a variable?

anakelka — Tue, 29 Sep 2020 14:07:12 GMT

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?

Re: How to color columns based on a variable?

somesoni2 — Thu, 18 May 2017 21:02:12 GMT

What is your search?

Re: How to color columns based on a variable?

kmorris_splunk — Thu, 18 May 2017 21:24:58 GMT

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.

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

Re: How to color columns based on a variable?

anakelka — Tue, 29 Sep 2020 14:07:34 GMT

| 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

Re: How to color columns based on a variable?

anakelka — Fri, 19 May 2017 12:28:27 GMT

I am unable to access the URL

Re: How to color columns based on a variable?

kmorris_splunk — Fri, 19 May 2017 12:42:45 GMT

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

Re: How to color columns based on a variable?

anakelka — Fri, 19 May 2017 13:15:05 GMT

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