Table Widget with Aggregation

September 01, 2015 13:24

*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.

AggregatedTable.dash

Comments

38 comments

Hymavathi Munagala July 09, 2019 12:15

Not working in

Version: 7.4.2.10063

0

Comment actions Permalink
Elliott Herz July 09, 2019 13:01

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

0

Comment actions Permalink
Nadia Savin July 09, 2019 21:33

Would have been nice to be notified of when a new version of a supported plugin is available, so users could proactively download a new version vs discovering an old one no longer works.

1

Comment actions Permalink
Tripti Jaiswal August 19, 2019 10:36

Plugin is not working in Version: 8.0.0.10134.

Thanks

Tripti

QBeeQ

qbeeq.pl

Official Sisense Partner

2019 Sisense Partner of the year

0

Comment actions Permalink
Benjamin Nissim December 04, 2019 12:42

Hi Guys,

It looks like the plug in crashes with BloX plug in

0

Comment actions Permalink
Siva February 07, 2020 10:51

Hello all,

This plugin is not working in Firefox. We use Sisense Js in our application.

Regards,

Siva.

0

Comment actions Permalink
Marat Khairullin August 12, 2020 07:33

Hello,

I found that this plugin affects the Look and Feel functionality. When plugin is on, the Table widget doesn't colorize (widget "table with aggregation" too).

0

Comment actions Permalink
Ivan Blagdan November 30, 2020 01:10

Hi,

When using the table widget with aggregation, are we able to use it to affect dashboard filters? I see it as an option and have it enabled but it doesn't seem to be working. When I right click into a row of the table, I do not see an option to "select" it as I do with the pivot widget.

0

Comment actions Permalink