Showing results for 
Search instead for 
Did you mean: 

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

Sisense Team Member
Sisense Team Member

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