veremeiev's avatar
veremeiev
Sisense Employee
08-27-2024
Status:
New Idea

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

Dashboards & Analytics

5 Comments

  • AssafHanina's avatar
    AssafHanina
    Sisense Employee
    09-08-2024

    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

  • AssafHanina's avatar
    AssafHanina
    Sisense Employee
    08-28-2024

    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's avatar
    csrobbie
    Data Storage
    09-03-2024

    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.