Specifying colors for my Column Graph based on it's value(s)

[maverick]

Hi Splunk Reporting Gurus,

Couple questions I'm wondering about:

1) Regarding the various columns in a column graph, is it possible to specify which colors are used for each column (attribute) or is that always automatic?

2) More specifically, can I configure a report to have different shades of green used for columns that are "greater than" a given number, and then have other columns be different shades of red if they are "less then" that given number?

Anyone done this type of reporting before?

[Dan]

In 4.2 you can now do field based coloring, which looks like this:

You cannot do any value based color assignments. The best you can do is formulate a search to rename fields that are above or below a certain value to something like "hi1", "hi2", "lo1", lo2", then assign colors to those fields as shown above.

(Credit to Jason Gatt)

[Ant1D]

Hi,

For your first question, you can control the colors of column chart cells. The colors used for cells will be in the order of the field values seen in your chart legend. In advanced XML inside your HiddenChartFormatter module, you will need to add the following param: <param name="charting.seriesColors">[0xCC0000,0x00CC00]</param>

In the above example, if you had a column chart with two cells, the first cell named Fail and the second named Pass, then the first hex value will make the Fail cell color Red and the pass cell color will be Green.

I am not sure about your second question. If this is possible, it would be very useful. I will look into it.