Introduction
Adding filter checkboxes in pivot tables will give your users a better interaction with the dashboard and allow them to perform multiple selections quickly and easily.
Purpose/Benefits
When showing a pivot table, this plugin provides a way to add checkboxes to cells, which gives the user a quick way to make multiple selections. It could be especially useful when using embedded dashboards where the filter panel is hidden.
Steps
In order to add The Pivot Checkboxes Plugin to a widget, please follow the listed steps below:
STEP 1 - DOWNLOAD AND EXTRACT THE ENCLOSED FOLDER INTO THE PLUGINS FOLDER:
- Download the latest version of the plugin from this link and extract the enclosed folder into the plugins folder:
/opt/sisense/storage/plugins/
Now, when you create a new pivot table widget the checkbox option should show up in the context menu of the ROWS dimensions.
STEP 2 - CONFIGURING THE PIVOT TABLE:
Create a pivot table in your dashboard and go into the widget’s editing window.
Make sure the pivot table is set to have Widget Affects Dashboard Filters and Enable Drill To Anywhere are DISABLED. Also make sure the dashboard filters are set to HIGHLIGHT. The widget settings should match the image below.
References/Notes
- Adding Checkboxes does not affect the Pivot if the cell contains clickable URLs
