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!

Extending Observability Content to Splunk Cloud

Register to join us !   In this Extending Observability Content to Splunk Cloud Tech Talk, you'll see how to ...

What's new in Splunk Cloud Platform 9.1.2312?

Hi Splunky people! We are excited to share the newest updates in Splunk Cloud Platform 9.1.2312! Analysts can ...

What’s New in Splunk Security Essentials 3.8.0?

Splunk Security Essentials (SSE) is an app that can amplify the power of your existing Splunk Cloud Platform, ...