How to color columns based on a variable?

[anakelka]

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?

[kmorris_splunk]

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.

[anakelka]

I am unable to access the URL

[kmorris_splunk]

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

[anakelka]

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

[somesoni2]

What is your search?

[anakelka]

| 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