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!

Data Management Digest – November 2025

  Welcome to the inaugural edition of Data Management Digest! As your trusted partner in data innovation, the ...

Splunk Mobile: Your Brand-New Home Screen

Meet Your New Mobile Hub  Hello Splunk Community!  Staying connected to your data—no matter where you are—is ...

Introducing Value Insights (Beta): Understand the Business Impact your organization ...

Real progress on your strategic priorities starts with knowing the business outcomes your teams are delivering ...