Pivot 2.0 - Add more than 3 measures in the "columns" pane

Sisense limits a user from defining more than 3 column values to make sure that the underlying SQL (group by) query doesn't get too complex (notice the missing '+'):

However, in some cases, a user would like to add more than 3 values. These include:

• A case where he requires a fourth group-by value
• A case where some of the columns are disabled (e.g., two alternating columns are enabled while the other 2 are always disabled)

Warning: Abusing this functionality may result in slow widget loading and/or timeouts

To change the default "Max Values" in the "Columns" pane - Follow the following steps:

1. Access the widget editing page
2. Open "Developer Mode" (F12) and access the console tab
3. Type the following Code:

   prism.activeWidget.metadata.panel('columns').$$manifest.metadata.maxitems = 5

4. Click "Apply" to save the changes to the widget
5. Access the widget editing page again:
   

    

Note: This change is persistent and doesn't require a widget script