Table Widget with Aggregation
*This plugin is officially supported by Sisense. You can find the latest version of this plugin on the Sisense Add-Ons page.
Introduction
The following article describes the steps needed to implement the “table widget with aggregation” plugin
Business Case
In some cases there is a need to sort a pivot table rows based on lowest granularity, however, since the pivot table groups the data, one can only sort the rows inside every group and not in the entire pivot. Aggregating the data in a table widget allows this kind of sorting.
Example
Sorting the most revenued categories by country can be done by 2 options:
-
Pivot table - allows to sort the brands in each category
-
Aggregated Table - enables to see the most revenued categories including the brands breakdown
Steps
Step 1 - Download and extract the enclosed folder into the plugins folder:
C:\Program Files\Sisense\PrismWeb\plugins\tableWidget, if the "plugins" folder is not there, please create it
Step 2 - Create a new widget
Step 3 - Click the drop down widget selector menu, and pick the TABLE WITH AGGREGATION. (Highlighted in the picture)
Step 4 - All new fields added to the table can now be aggregated
* The plugin was updated to work on version 6
*****UPDATE Aug 30th, 2017: Export to PDF is now working on version 6.6.1 and above.
-
Hi Hymavathi,
Have you tried removing the plugin, and redownloading/installing from the marketplace? I had the same behavior a week ago, and just had to remove the outdated plugin and install the new one. It's possible that the name of the plugin in the plugin folder changed as well. Just make sure you don't have 2 versions of the same plugin.
Best, Elliott
Please sign in to leave a comment.
Comments
35 comments