How to increase row count on the heatmap viz chart

[ksoori]

as you can see the heatmaps shows only 10 rows. how to increase this? i would like to use the heatmap to show all 100 servers we have.

[spavin · Accepted solution]

Hi @ksoori,

The heatmap viz can show all 100 servers - I suspect you're running into the default limit for | timechart

Try adding this to your timechart command: limit=0

e.g:
|index=main
|timechart avg(cpu) by host limit=0

That will allow all 100 servers to be included in the output, rather than aggregating most into an "other" field.

Once you've done that there are a couple of options you should probably set to accommodate so many rows:

• Set the height to 1000. That's the most you can set a visualisation in a dashboard, and should give you enough room to display all 100 hosts.
  <option name="height">1000</option>

• Set the font-height to 12px - that will make the visualization more readable:

<option name="heat-map-viz.heat-map-viz.labelFontSize">12</option>

• Turn off animations. You may still like it twinkling, but it could get annoying with so many data points: <option name="heat-map-viz.heat-map-viz.enableAnimation">false</option>

Cheers,
Daniel