topic Re: Is there a way to display more than 20 charts at a time using new trellis layout? in Dashboards & Visualizations

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

ksarpol — Wed, 17 May 2017 01:51:32 GMT

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.

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

DalJeanis — Wed, 17 May 2017 15:03:16 GMT

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.

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

ksarpol — Wed, 17 May 2017 17:38:29 GMT

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.

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

joshuayourth — Mon, 17 Jul 2017 20:19:09 GMT

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.

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

niketn — Tue, 18 Jul 2017 07:48:36 GMT

@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.

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

jtrujillo — Wed, 07 Mar 2018 23:23:20 GMT

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

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

rithvikmundra — Thu, 21 Jun 2018 18:06:55 GMT

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

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

I868162 — Tue, 03 Jul 2018 21:37:45 GMT

Hi @ksarpol and @joshuayourth,

Did you ever find the solution to this?

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

ksarpol — Tue, 03 Jul 2018 22:18:01 GMT

I did not. 😞

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

dijikul — Wed, 15 Aug 2018 19:05:57 GMT

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.

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

AnilPujar — Sun, 14 Oct 2018 06:42:07 GMT

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.

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

efavreau — Thu, 18 Oct 2018 13:53:42 GMT

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.

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

niketn — Thu, 18 Oct 2018 14:37:44 GMT

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

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

efavreau — Thu, 18 Oct 2018 17:32:41 GMT

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

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

bandit — Fri, 26 Oct 2018 00:33:39 GMT

Yes, please up trellis limit and add sort option

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

fsolercasanova — Wed, 24 Apr 2019 21:49:58 GMT

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

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

woodcock — Mon, 25 Nov 2019 17:28:21 GMT

There is now a JIRA on this ( SPL-176965 ) that also covers the fact that for trellis, we need a $click.name3$ for the BY field. if I have pie-charts trellissed BY host and I click on the pie-chart for host foo, I have no way to get the foo string to use for the drilldown, which is criminal. Supposedly all this will be fixed in the Dashboards (Beta) app first, when they roll trellis into it:
https://splunkbase.splunk.com/app/4710/

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

pgadhari — Tue, 31 Dec 2019 06:20:39 GMT

@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 ?

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

to4kawa — Tue, 31 Dec 2019 08:54:50 GMT

With simpleXML, there are 20 restrictions, so it would be unavoidable to attach the dashboard using base search and where
Individual queries are not so difficult

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

pgadhari — Tue, 31 Dec 2019 09:09:50 GMT

@to4kawa did not get it.. can you explain in more details how this can be achieved using base search ? You mean to say I have to use 156 individual searches to show each box ?