Show more than 70 columns in a pivot2 (without changing the global setting)

[cjakerle]

Hello,

We have a situation where we need to show 3 different values for each day of a month in a pivot (so, up to 93 max columns).  I know there is a global setting to expand the number of columns on a pivot2 (default of 70, I assume we could go up to 93 on that, if necessary).  Generally, I like the 70 column limit so I'd like this to be a one-off exception rather than increasing for everyone.  In the old Windows version, there was a script out on the community that could allow more than x columns to show.  Anyone have a script to do this with Pivot2 in Linux?

Thanks,
Chris

[MikeGre]

Hi @cjakerle ,

Have a look at this:

https://community.sisense.com/t5/build-analytics/pivot-widget-maximum-number-of-values/m-p/20351/thr...

It works for us! 

[cjakerle]

@MikeGre  - thanks so much for the quick response!  What's interesting about that post is that I think it allows you to add more than "x" columns at design time.  So, it enables the "+" sign when normally it would get disabled after "x" columns.  In this case, I only have three columns under "Values".  It's because I have a "Columns" value that is the dates in a month, sometimes it is more than 70 and sometimes it is not, based on how far into "This month" we are.  It is always more than 70 if I filter to past months.  So, it is only at run time the number of columns expands beyond 70 and I get a little yellow icon that says 

The Pivot table is limited to 70 columns.
Totals may refer to the complete data if set by the dashboard owner.
If available, you can use filters to display fewer rows and columns.
To view all your data, download the table to CSV.
(This message will be shown to your dashboard users).

I did try the script but it doesn't seem to change this particular behavior.  I tried looking around in the pivot2 documentation a bit to see if there was another setting I could spot, but didn't see anything.  

I wonder if anyone has just expanded the max number of columns for the entire server to be more than 70?  I suppose setting that to something like 95 will cover me here and it's only 25 more than what's already there.  It's still limited so that people don't do 200 columns or something wild.  

If there are any other suggestions out there, please let me know.  

Thanks,
Chris

[DRay · Accepted solution]

Hi @cjakerle.

You can definitely change the global setting to 95. Do you have a test environment you can try it with to see what the impact may be? If not, I recommend closely monitoring the server performance after you increase the global limit to make sure the system performance is acceptable.

[cjakerle]

Thanks, @DRay .  I think updating the global setting is the way to go.  I updated in a test server with no load and it went fine.  I'll try it in Prod and watch it as you suggested.