Splunk Search

How to color the field greater than or lower than or between?

jip31
Motivator

Hi

Im a report, I am doing a basic count on a field

| stats values(CycleCount00) as "Cycle count" by host

when "Cycle count" result is > 300, I need to color the field in red
when "Cycle count" result is between 200 and 300, I need to color the field in orange
when "Cycle count" result is < 200, I need to color the field in green

what is the better way to do this?
I have also tried this it doesnt let me to user greater or lower than...

       <format type="color" field="Cycle count">
          <colorPalette type="minMidMax" maxColor="#31A35F" minColor="#FFFFFF"></colorPalette>
          <scale type="minMidMax"></scale>
        </format>

Ithought about the rangemap command but I dont succeed to use it
is anybody cant help me please?

0 Karma
1 Solution

to4kawa
Ultra Champion
<dashboard>
  <label>table sample</label>
  <row>
    <panel>
      <table>
        <search>
          <query>| makeresults count=3
| streamstats count
| eval "Cycle count" = random() % 300 ,host="host_".count
| table host "Cycle count"</query>
          <earliest>0</earliest>
          <latest></latest>
          <sampleRatio>1</sampleRatio>
        </search>
        <option name="count">20</option>
        <format type="color" field="Cycle count">
          <colorPalette type="list">[#53A051,#F1813F,#DC4E41]</colorPalette>
          <scale type="threshold">200,300</scale>
        </format>
      </table>
    </panel>
  </row>
</dashboard>

rangemap is not need.

View solution in original post

0 Karma

to4kawa
Ultra Champion
<dashboard>
  <label>table sample</label>
  <row>
    <panel>
      <table>
        <search>
          <query>| makeresults count=3
| streamstats count
| eval "Cycle count" = random() % 300 ,host="host_".count
| table host "Cycle count"</query>
          <earliest>0</earliest>
          <latest></latest>
          <sampleRatio>1</sampleRatio>
        </search>
        <option name="count">20</option>
        <format type="color" field="Cycle count">
          <colorPalette type="list">[#53A051,#F1813F,#DC4E41]</colorPalette>
          <scale type="threshold">200,300</scale>
        </format>
      </table>
    </panel>
  </row>
</dashboard>

rangemap is not need.

0 Karma

jip31
Motivator

perfect thanks

0 Karma

nickhills
Ultra Champion

You should be able to use rangemap for this.

Try:

...| stats values(CycleCount00) as "Cycle count" by host|rangemap field="Cycle count" low=0-200 elevated=201-300 default=severe

In your table, add:

<option name="classField">range</option>
If my comment helps, please give it a thumbs up!
0 Karma

jip31
Motivator

when I add the option name range I have a issue :
Unknown option name="classField" for node="table"

0 Karma
Get Updates on the Splunk Community!

Introducing the 2024 Splunk MVPs!

We are excited to announce the 2024 cohort of the Splunk MVP program. Splunk MVPs are passionate members of ...

Splunk Custom Visualizations App End of Life

The Splunk Custom Visualizations apps End of Life for SimpleXML will reach end of support on Dec 21, 2024, ...

Introducing Splunk Enterprise 9.2

WATCH HERE! Watch this Tech Talk to learn about the latest features and enhancements shipped in the new Splunk ...