Re: How to add a static table in dashboard?

splunkrocks2014 · ‎01-26-2017

I added a following table to my dashboard mainly to show the legends from a statistics table. The table showed the legends and contents properly, but the statistics table did not work any more. I guess this is not the right way to add a static table to the Splunk dashboard. Any suggestion? Thanks.

<form>        
              ...
             <option name="count">100</option>
          </table>
        </panel>
      </row>
      <row>
        <panel>
          <html>
            <center>
            <table id="legend" style="width:80%;text-align:center">
            <tr>
              <td style="width:20%;background-color:#4B4B4B;color:white;">legend_1</td>
              <td style="width:20%;background-color:#C8A2C8;color:white;">legend_2</td>
              <td style="width:20%;background-color:#DF3737;color:white;">legend_3</td>
              <td style="width:20%;background-color:#FFA100;color:white;">legend_4</td>
              <td style="width:20%;background-color:#15B85E;color:white;">legend_5</td>
              </tr>
            </table>
            </center>
           </html>
        </panel>
      </row>
</form>

woodcock · ‎03-04-2017

Here is some sample XML that demonstrates coloring of cells (the colorPalette part) in a Statistics Table depending on values:

<panel>
  <title>Your Title Here</title>
  <table>
    <title>Your Other Title Here</title>
    <search>
      <query>Your Search Query That Generates A Table Here</query>
      <earliest>$earliest$</earliest>
      <latest>$latest$</latest>
    </search>
    <option name="count">2</option>
    <option name="dataOverlayMode">none</option>
    <option name="drilldown">cell</option>
    <option name="percentagesRow">false</option>
    <option name="rowNumbers">false</option>
    <option name="totalsRow">false</option>
    <option name="wrap">true</option>
    <format type="color" field="count">
      <colorPalette type="map">{"1000":#A2CC3E,"10000":#F7BC38,"50000":#F7BC38,"100000":#A2CC3E,"101000":#D93F3C}</colorPalette>
    </format>
  </table>
</panel>

somesoni2 · ‎01-26-2017

What version of Splunk this html doesn't work??

splunkrocks2014 · ‎01-26-2017

Splunk version 6.3.7

somesoni2 · ‎01-26-2017

Above simple xml snippet for html tag worked fine for me in 6.3.8. When you say "but the statistics table did not work any more", what doesn't work? you don't see colors or what?

splunkrocks2014 · ‎01-26-2017

From the statistics table, it shows as "Search is waiting for input...", but it never shows any results.

somesoni2 · ‎01-26-2017

It's output of an html code so, changing the panel type to statistics table would not fetch anything (not sure if that's possible). If you're looking to recreate the same html panel as Splunk statistics table, will colored cell, first you need to write a Splunk search to return the table in the format that you need and then you need to use methods described in below links to color the cells.

https://answers.splunk.com/answers/230164/how-to-get-a-table-cell-color-to-change-depending.html
https://answers.splunk.com/answers/418487/how-to-set-up-table-cell-highlighting-with-differe.html

How to add a static table in dashboard?

Join Us for Splunk University and Get Your Bootcamp Game On!

.conf24 | Learning Tracks for Security, Observability, Platform, and Developers!

Announcing Scheduled Export GA for Dashboard Studio