Interactive Pivot

By Sisense

Overview
Technical Details
Pricing
Release Notes

Standard pivots can contain rows, columns, and values, but sometimes displaying all of the loaded data on the dashboard isn't necessary for the viewer. The Interactive Pivot add-on provides the option to enable/disable rows, columns, and values on the dashboard level from a cell's menu.

To install the Interactive Pivot add-on:

Download the attachment.
Extract the .zip folder into the plugins folder. If the folder does not exist, create it prior to extracting the .zip file.
For V7.1 and earlier: C:\Program Files\Sisense\PrismWeb\plugins
For V7.2 and later: C:\Program Files\Sisense\app\plugins
After those files have been unzipped there, you may also have to restart the web server.

Implementation:

Create a new pivot widget or edit existing pivot widget.
Add all items for rows/ values/ columns that are relevant to this widget
On the design panel enable the “Interactive Pivot” option
Apply your changes
Refresh the dashboard

Using the plugin:

When right clicking the headers or the rows, you will have the option to remove the selected field or add additional fields to the pivot for the rows, values or break by.

Limitations:

Changes are not saved on SisenseJS – additional fields are deleted on page refresh
When the widget is on a drill state – it is not allowed to remove columns and rows.

This is a premium Sisense add-on. For pricing details please get in touch with your CSM: Get the Add-On

4/25/2019: Added scroll functionality if menu content overlaps the window

5/3/2019: Fix menu scroll for Sisense JS

9/10/2019: Remove the minified version

9/10/2019: Added support for 7.4.3+7.4.4. Upgraded readme file

1/31/2020: Added Linux support

22/4/2020: Added compatibility with Sisense 8.2

19/5/2020: Added compatibility with Sisense 8.2.1

16/6/2020: Added compatibility with Sisense 8.2.2

21/5/2020: Fixed issue with not working sort arrow on hover

1/7/2020: Added compatibility with Sisense L8.0.5

24/7/2020: Added compatibility with Sisense 8.2.3

28/8/2020: Added compatibility with Sisense 8.2.4

23/9/2020: Added support for IE browser (Linux)

23/9/2020: Fixed duplicated menu

23/9/2020: Fixed compatibility issue with “printToPrinter” plugin on Linux

23/10/2020: Added compatibility with Sisense 8.2.5

28/12/2020: Added compatibility with Sisense L8.2.6

15/02/2021 Fixed missing scroll in case when were added too much measures in the pivot

17/02/2021: Added compatibility with Sisense L2021.1.1

22/02/2021: Fixed error in the console on the login page

7/04/2021: Added compatibility with Sisense L2021.1.4, L2021.3.1, 2021.2

5/07/2021: Added compatibility with Sisense L2021.3.2

5/07/2021: Fixed issue when the field was not removed in specific cases

7/07/2021: Added compatibility with Sisense L2021.5.0