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:
- Access the widget editing page
- Open "Developer Mode" (F12) and access the console tab
- Type the following Code:
prism.activeWidget.metadata.panel('columns').$$manifest.metadata.maxitems = 5 - Click "Apply" to save the changes to the widget
- Access the widget editing page again:
Note: This change is persistent and doesn't require a widget script
