The limit of values in a Pivot Table more than 20

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

Vitalii Veremeiev

Posted 2 years ago·Last reply 2 years ago

5 comments

Assaf Hanina

·2 years ago

csrobbie thanks for the confirmation!

csrobbie

·2 years ago

That resolved it. Thanks!

Assaf Hanina

·2 years ago · Edited

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:

Open the Pivot Widget Edit Script

Copy the Script and Save

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

Refresh the Entire Page
Plus Button is added

Please update if this resolve the issue

Best Regards

Assaf

csrobbie

·2 years ago

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.

Assaf Hanina

·2 years ago

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){<br/><br/>p.metadata.maxitems = 30; //replace with the number you need<br/><br/>})

Best Regards

Assaf