Product Feedback Forum
Help us make Sisense better by posting your product feedback here.
cancel
Showing results for 
Search instead for 
Did you mean: 
Status: New Idea

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

5 Comments

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

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

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. 

AssafHanina_0-1725831284932.png

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
    AssafHanina_1-1725831478244.png

Please update if this resolve the issue

Best Regards

Assaf

That resolved it. Thanks!

@csrobbie thanks for the confirmation!