Dashboards & Visualizations

How to set table/panel height via whatever means possible?

DEAD_BEEF
Builder

Like the title says, I'm looking to fix the height on a bunch of panels (stat tables) within my dashboard. I've already set how many rows they can have but there is a TON of extra white space. How can I fix the height value to a constant? I've seen answers when it involves a chart but I am using statistics tables so the option name=height doesn't seem to work for that.

Would like an xml answer if possible but open to anything else.

alt text

0 Karma
1 Solution

adonio
Ultra Champion

limit rows in a table so they all align:

use this: <option name="count">20</option>

example:

<dashboard>
  <label>Limit Rows</label>
  <row>
    <panel>
      <title>20 rows</title>
      <table>
        <search>
          <query>| makeresults count=100
| eval random=random()%100</query>
          <earliest>-24h@h</earliest>
          <latest>now</latest>
          <sampleRatio>1</sampleRatio>
        </search>
        <option name="count">20</option>
        <option name="dataOverlayMode">none</option>
        <option name="drilldown">none</option>
        <option name="percentagesRow">false</option>
        <option name="rowNumbers">false</option>
        <option name="totalsRow">false</option>
        <option name="wrap">true</option>
      </table>
    </panel>
    <panel>
      <title>15 rows</title>
      <table>
        <search>
          <query>| makeresults count=100
| eval random=random()%100</query>
          <earliest>-24h@h</earliest>
          <latest>now</latest>
          <sampleRatio>1</sampleRatio>
        </search>
        <option name="count">15</option>
        <option name="dataOverlayMode">none</option>
        <option name="drilldown">none</option>
        <option name="percentagesRow">false</option>
        <option name="rowNumbers">false</option>
        <option name="totalsRow">false</option>
        <option name="wrap">true</option>
      </table>
    </panel>
    <panel>
      <title>10 rows</title>
      <table>
        <search>
          <query>| makeresults count=100
| eval random=random()%100</query>
          <earliest>-24h@h</earliest>
          <latest>now</latest>
          <sampleRatio>1</sampleRatio>
        </search>
        <option name="count">10</option>
        <option name="dataOverlayMode">none</option>
        <option name="drilldown">none</option>
        <option name="percentagesRow">false</option>
        <option name="rowNumbers">false</option>
        <option name="totalsRow">false</option>
        <option name="wrap">true</option>
      </table>
    </panel>
  </row>
</dashboard>

screenshot:

alt text

View solution in original post

adonio
Ultra Champion

limit rows in a table so they all align:

use this: <option name="count">20</option>

example:

<dashboard>
  <label>Limit Rows</label>
  <row>
    <panel>
      <title>20 rows</title>
      <table>
        <search>
          <query>| makeresults count=100
| eval random=random()%100</query>
          <earliest>-24h@h</earliest>
          <latest>now</latest>
          <sampleRatio>1</sampleRatio>
        </search>
        <option name="count">20</option>
        <option name="dataOverlayMode">none</option>
        <option name="drilldown">none</option>
        <option name="percentagesRow">false</option>
        <option name="rowNumbers">false</option>
        <option name="totalsRow">false</option>
        <option name="wrap">true</option>
      </table>
    </panel>
    <panel>
      <title>15 rows</title>
      <table>
        <search>
          <query>| makeresults count=100
| eval random=random()%100</query>
          <earliest>-24h@h</earliest>
          <latest>now</latest>
          <sampleRatio>1</sampleRatio>
        </search>
        <option name="count">15</option>
        <option name="dataOverlayMode">none</option>
        <option name="drilldown">none</option>
        <option name="percentagesRow">false</option>
        <option name="rowNumbers">false</option>
        <option name="totalsRow">false</option>
        <option name="wrap">true</option>
      </table>
    </panel>
    <panel>
      <title>10 rows</title>
      <table>
        <search>
          <query>| makeresults count=100
| eval random=random()%100</query>
          <earliest>-24h@h</earliest>
          <latest>now</latest>
          <sampleRatio>1</sampleRatio>
        </search>
        <option name="count">10</option>
        <option name="dataOverlayMode">none</option>
        <option name="drilldown">none</option>
        <option name="percentagesRow">false</option>
        <option name="rowNumbers">false</option>
        <option name="totalsRow">false</option>
        <option name="wrap">true</option>
      </table>
    </panel>
  </row>
</dashboard>

screenshot:

alt text

DEAD_BEEF
Builder

Thanks @adonio! I set each table to the same row count and it auto-consolidated the space once I saved changes.

0 Karma

adonio
Ultra Champion

hello there,

you can use the:
<option name="height">700</option> in your xml code:

try out this dashboard:

<dashboard>
  <label>2 panels dashboard</label>
  <row>
    <panel>
      <title>panel 1 height=100</title>
      <chart>
        <search>
          <query>| gentimes start="11/22/2018:00:00:00" end="11/28/2018:10:00:00" increment=1h
| eval _time = starttime 
| eval percentageValue = random()%100
| eval ID = random()%5
| eval IDValue = "id". "-" .ID
| timechart span=1h avg(percentageValue) as avg_value by IDValue</query>
          <earliest>-60m@m</earliest>
          <latest>now</latest>
          <sampleRatio>1</sampleRatio>
        </search>
        <option name="charting.axisTitleX.visibility">visible</option>
        <option name="charting.axisTitleY.visibility">visible</option>
        <option name="charting.axisTitleY2.visibility">visible</option>
        <option name="charting.chart">line</option>
        <option name="charting.chart.nullValueMode">connect</option>
        <option name="charting.drilldown">all</option>
        <option name="charting.legend.placement">right</option>
        <option name="refresh.display">progressbar</option>
        <option name="trellis.enabled">0</option>
        <option name="height">100</option>
      </chart>
    </panel>
    <panel>
      <title>panel2 height=700</title>
      <chart>
        <search>
          <query>| gentimes start="11/22/2018:00:00:00" end="11/28/2018:10:00:00" increment=1h
| eval _time = starttime 
| eval percentageValue = random()%100
| eval ID = random()%5
| eval IDValue = "id". "-" .ID
| timechart span=1h avg(percentageValue) as avg_value by IDValue</query>
          <earliest>-60m@m</earliest>
          <latest>now</latest>
          <sampleRatio>1</sampleRatio>
        </search>
        <option name="charting.axisTitleX.visibility">visible</option>
        <option name="charting.axisTitleY.visibility">visible</option>
        <option name="charting.axisTitleY2.visibility">visible</option>
        <option name="charting.chart">line</option>
        <option name="charting.chart.nullValueMode">connect</option>
        <option name="charting.legend.placement">right</option>
        <option name="height">700</option>
        <option name="refresh.display">progressbar</option>
        <option name="trellis.enabled">0</option>
      </chart>
    </panel>
  </row>
</dashboard>

screenshot:
alt text

hope it helps

DEAD_BEEF
Builder

Thanks for providing both answers. This answer works for <chart> but not <table>. Still useful info for future readers.

0 Karma

impurush
Contributor

FYI, I understand from his question is that he wants to set the table/panel height when it is a statistics table but not for the chart.

Get Updates on the Splunk Community!

Adoption of RUM and APM at Splunk

    Unleash the power of Splunk Observability   Watch Now In this can't miss Tech Talk! The Splunk Growth ...

March Community Office Hours Security Series Uncovered!

Hello Splunk Community! In March, Splunk Community Office Hours spotlighted our fabulous Splunk Threat ...

Stay Connected: Your Guide to April Tech Talks, Office Hours, and Webinars!

Take a look below to explore our upcoming Community Office Hours, Tech Talks, and Webinars in April. This post ...