Is there a way to display more than 20 charts at a time using new trellis layout?

[ksarpol]

I have 30 hosts. I would like to see a chart of all 30 hosts using the trellis layout but only 20 (2 rows of 10 each) are displayed at a time. I know I can use the "Next" link to see the remaining 10 charts but I want to see all 30 at once so I can put it on a operations monitor.

Is there a way to display more than 20 charts using trellis layout?

The documentation makes no mention of any limits.

Limitations
     Fields generated with the eval command appear as aggregations in the trellis layout configuration menu.
     Trellis layout is not available for table visualizations or cluster maps.
     A predefined token is not available for aggregations used for splitting a visualization.
     Visualizations using trellis layout do not render in dashboard PDFs.

[pgadhari]

@woodcock @niketnilay Is there any solution for this problem. I am also facing the same issue ? I want to show 156 hosts in a single panel on a single page. Please help ?

[woodcock]

See my new answer.

[fsolercasanova]

A simple workaround that you might be willing to implement:

You can create a base search and have two trellis panels based off it in separate rows. Pull the 20 hosts for Trellis Panel 1 and exclude those same hosts from Trellis Panel 2. If the number of hosts goes up this can just be chained every time one of the trellis panels reaches the maximum limit.

https://docs.splunk.com/Documentation/Splunk/7.2.6/Viz/Savedsearches#Post-process_searches

[efavreau]

At the time of this answer, I was not able to find a way. In the latest documentation, http://docs.splunk.com/Documentation/Splunk/7.2.0/Viz/ChartConfigurationReference and http://docs.splunk.com/Documentation/Splunk/7.2.0/Viz/VisualizationTrellis, there is the following:

Use the Trellis menu to adjust the segment size and show more segments in the panel. You can also use the dashboard editor to drag the panel size or change the panel height option in Simple XML.

I added the following into my simple xml dashboard panel source:

<option name="charting.data.count">0</option>
<option name="height">10000</option>

The panel height maximum limit is documented at 10000, which made for a quite large panel. However, the trellis still stopped at 20, and did not fill the panel. It would appear we have reached a physical limit with no known workaround/override.

[niketn]

@efavreau, I have have converted your Answer to comment as it does not have a solution.

[efavreau]

@niketnilay Thank you! Appreciate your help - as always.

[joshuayourth]

I'm in the same boat as you. I have 22 hosts that I'm monitoring, so I have 20 on one page, and then a tab of 2 more. Quite annoying.

[I868162]

Hi @ksarpol and @joshuayourth,

Did you ever find the solution to this?

[ksarpol]

I did not. 😞

[AnilPujar]

Yes, same problem ... there should be some option to increase the trellis limit per page.

As each row will display 6 viz per row, so it will look like :

VIZ VIZ VIZ VIZ VIZ VIZ
VIZ VIZ VIZ VIZ VIZ VIZ
VIZ VIZ
<1,2>
I have 21 Sourcetypes, so just for one more viz i need to click 2nd page, when there are places in the first screen itself.

[DalJeanis]

None of the demos showed more than two rows of segments, so they may not have anticipated the need for three... which seems odd...

Here's the only note I found that might be helpful... from the same page - https://docs.splunk.com/Documentation/Splunk/latest/Viz/VisualizationTrellis

Use the Trellis menu to adjust the segment size and show more segments in the panel. You can also use the dashboard editor to drag the panel size or change the panel height option in Simple XML.

I assume you already set the segments as small, so playing with the XML height is the only obvious option.

[niketn]

@DalJeanis, rather than showing results in two rows, I believe the current settings are showing "20 results/splits per page" similar to what table has by default (20 rows /50 rows or 100 rows per page). I feel there should be an enhancement to Trellis Layout to have the options to switch between 20 results/50 results etc.

[jtrujillo]

I upvoted this. It should 100% be configurable in the trellis options...

[rithvikmundra]

I definitely agree with @niketnilay. We need more than 20 results in a trellis layout.

[bandit]

Yes, please up trellis limit and add sort option

[ksarpol]

Thanks for responding. I am using "small" size and changing the panel size seems to have no effect. I'm going to have to create 2 panels with 15 in each to get what I'm looking for. Splunk developers seems have a habit of releasing new features that are half-baked.

[dijikul]

This right here seems to hit the nail on the head. I was shocked to learn the deprecation of Advanced XML in Splunk 7 prevents me from shading an area chart with a gradient - easily achievable with CSS, but having to explort dashboards to HTML to customize is huge workflow overhead for turning around quick (and pretty) visualization in compared to some other tools.

Splunk wins in terms of obtaining access to data and making it available, but presentation is definitely not it's strength.