topic How can I show different colors to match specific ranges on a single value dashboard panel? in Dashboards & Visualizations

How can I show different colors to match specific ranges on a single value dashboard panel?

barunbiswas — Wed, 20 Sep 2017 06:18:08 GMT

I am working on a single value dashboard panel where I am showing results in percentage. I want to show different range in different colors. So, I have defined the below range:
min to 30.99 -> green
30.99 to 60.99 -> yellow
60.99 to 89.99 -> amber
89.99 to max -> red
in the XML form, there are 4 values inside rangeColors (green, yellow, amber, red) and 3 values (30.99, 60.99, 89.99) inside rangeValues.

The above definition is showing 0.00 in red (!), when it should be shown in green. Could you advise me on this please?

Re: How can I show different colors to match specific ranges on a single value dashboard panel?

Sukisen1981 — Wed, 20 Sep 2017 06:43:57 GMT

hi, can you share the xml piece of code where you are doing this?
As it is of course , this looks perfect but it would be better to see your xml code where you are setting the range colours

Re: How can I show different colors to match specific ranges on a single value dashboard panel?

barunbiswas — Wed, 20 Sep 2017 08:14:12 GMT

Please find below the xml code for this.

["0x65a637","0xf7bc38","0xf58f39",0xd93f3c"]
[30.99,60.99,89.99]

Re: How can I show different colors to match specific ranges on a single value dashboard panel?

alemarzu — Wed, 20 Sep 2017 20:18:25 GMT

Did you try by changing them from the UI ?

Re: How can I show different colors to match specific ranges on a single value dashboard panel?

barunbiswas — Thu, 21 Sep 2017 08:42:54 GMT

yes, tried. However, it is not working correctly always. Here, I am saying always because sometimes it showing color correctly, sometimes not. It seems something is not correct with the Splunk options itself, however, not sure.

Re: How can I show different colors to match specific ranges on a single value dashboard panel?

cmerriman — Thu, 05 Oct 2017 19:57:59 GMT

i created a dashboard using |makeresults|eval data=0.00 and put those values into my format and it seems to work. I'm using Splunk v 6.6.2. what version are you on? This might be worth a support ticket.

<dashboard>
  <label>randomtest</label>
  <row>
    <panel>
      <single>
        <search>
          <query>|makeresults|eval data=0.00</query>
          <earliest>-24h@h</earliest>
          <latest>now</latest>
        </search>
        <option name="drilldown">none</option>
        <option name="numberPrecision">0.00</option>
        <option name="rangeColors">["0x65a637","0x6db7c6","0xf7bc38","0xd93f3c"]</option>
        <option name="rangeValues">[30.99,60.99,89.99]</option>
        <option name="useColors">1</option>
      </single>
    </panel>
  </row>
</dashboard>

Re: How can I show different colors to match specific ranges on a single value dashboard panel?

niketn — Fri, 06 Oct 2017 14:36:36 GMT

@barunbiswas, can you share the other Single Value Simple XML Configuration options? By any chance have you chosen the option to color by trend?

Re: How can I show different colors to match specific ranges on a single value dashboard panel?

riddhichandaran — Fri, 12 Apr 2019 09:16:41 GMT

Hey @barunbiswas
please try below code, hope it will help you!

<dashboard>
  <label>splunk_answer</label>
  <row>
    <panel>
      <single>
        <search>
          <query>index=_internal | stats count | eval count=0</query>
          <earliest>-24h@h</earliest>
          <latest>now</latest>
        </search>
        <option name="drilldown">none</option>
        <option name="numberPrecision">0.00</option>
        <option name="rangeColors">["0x53a051","0xFFFF00","0xffbf00","0xdc4e41"]</option>
        <option name="rangeValues">[30.99,60.99,89.99]</option>
        <option name="refresh.display">progressbar</option>
        <option name="useColors">1</option>
      </single>
    </panel>
  </row>
</dashboard>