Splunk Search

How to display search results like a heatmap?

jip31
Motivator

Hi

I use the search below

 

<row>
    <panel>
      <table>
        <search>
          <query>index=toto sourcetype=tutu
| timechart span=5m perc90(citr) as cit</query>
          <earliest>-4h@m</earliest>
          <latest>now</latest>
        </search>
        <option name="drilldown">none</option>
        <option name="refresh.display">progressbar</option>
        <format type="color" field="citr>
          <colorPalette type="list">[#DC4E41,#F1813F,#53A051]</colorPalette>
          <scale type="threshold">0,22000,24000,27000</scale>
        </format>
      </table>
    </panel>
  </row>

 

As you can see, the results are colored in green, orange or red following the result value 

I would like to display the results like an heatmap

It means that I would like to have the _time fields in an x axis and to display just the color results without the value results

something like this

jip31_0-1646461842055.png

 

Is is possible to do that just with a table viz?

Regards

Labels (1)
0 Karma
Get Updates on the Splunk Community!

Shape the Future of Splunk: Join the Product Research Lab!

Join the Splunk Product Research Lab and connect with us in the Slack channel #product-research-lab to get ...

Auto-Injector for Everything Else: Making OpenTelemetry Truly Universal

You might have seen Splunk’s recent announcement about donating the OpenTelemetry Injector to the ...

[Puzzles] Solve, Learn, Repeat: Character substitutions with Regular Expressions

This challenge was first posted on Slack #puzzles channelFor BORE at .conf23, we had a puzzle question which ...