The limit of values in a Pivot Table more than 20

[veremeiev]

It would be great to have settings that allow adjusting the limit of values in a Pivot Table, similar to the existing option for changing the maximum number of columns displayed.

Currently, we can only adjust the maximum number of columns displayed in the Pivot Table configuration. This can be done via the Admin tab by navigating to Server & Hardware > System Management > Configuration. From there, go to Pivot Table and set the Maximum number of columns to display

We also have a WA for this using a widget script: https://community.sisense.com/t5/product-feedback-forum/idb-p/ideas/tab/most-recent
However, it would be great to have it for all the widgets without using scripts

[AssafHanina]

hey @veremeiev ,

Adjusting the Values can be done using a Widget Script.
Please refer to the related community link

widget.manifest.data.panels.forEach(function(p){

p.metadata.maxitems = 30; //replace with the number you need

})

Best Regards

Assaf

[csrobbie]

@AssafHanina this script doesn't seem to work in terms of allowing for than 20 values. The referenced link appears to be related to adding more rows, which is not the question and it doesn't look like it has a solution for that. 

[AssafHanina]

hey @csrobbie ,

I assume is the ability to add More Measures/Values over 20. 
Please find related Screenshot of Pivot table without applying the script, hence - the Plus button is missing when the pivot has 20 measures. 

Steps: 

1. Open the Pivot Widget Edit Script
2. Copy the Script and Save
   

   widget.manifest.data.panels.forEach(function(p){
   p.metadata.maxitems = 100; //replace with the number you need
   })​

3. Refresh the Entire Page 
4. Plus Button is added
   

Please update if this resolve the issue

Best Regards

Assaf

[csrobbie]

That resolved it. Thanks!

[AssafHanina]

@csrobbie thanks for the confirmation!