cancel
Showing results for 
Search instead for 
Did you mean: 
intapiuser
Community Team Member
Community Team Member
Sisense has several different ways to present table data. Often we pick whichever one we find first that seems to work, instead of picking the table that best meets our requirements. This can result in unnecessarily slow dashboards. 
Table:
A table is the simplest widget. It displays raw data with no transformations done to it. It lacks things like aggregations, jump to dashboard, and selection. It is excellent for creating dashboards that will be primarily used as reports as there are not many ways to interact with a table. The table is the fastest performing widget on this list. 
 
Table with Aggregation:
Much like a table, it lacks most of the features of a pivot but does allow aggregation. Use this when creating simple reports that need aggregation. 
 
Pivot:
Pivot tables are the most flexible of our table widgets capable of aggregations, column, sub totals, drill down, and more. Pivots are the most time consuming widget to render on Sisense and so great care should be paid to the performance of dashboards using large amounts of pivots. 
*Pivot is fundamentally different between Windows and Linux. Linux pivot (Pivot2) performs better and has additional features. Pivot2 also has an API to easily customize your pivot widgets*

Blox:
It is possible to create a table in Blox! This table can do aggregation and selections (like jump to dashboard and filtering) but this requires writing specific widget logic. You will also have to do more to style Blox like a table. It loads about as quickly as a generic widget like a column chart. Blox is a good choice when you need the aggregations and selection of a pivot table but can't afford the performance hit, but it will require much more time to develop and maintain on the customer end. This approach is not generally recommended. 
 
We have summarised the information in this post into a table for quick digestion and future reference.  
 
Feature\Widget
Table
Table w/ Aggregation
Pivot
Blox
Aggregations
No
Yes
Yes

Must be done in widget
Drill down
No
No
Yes
No
Selections (filters, jump to dashboard)
No
No
Yes
Yes
Excel export
No
No
Yes
No
Sub totals/Grand totals
No
No
Yes

Must be done in widget
Performance
Fastest
Faster than pivot, slower than table
Slowest
As fast as a generic widget
Uses
For exporting user reports
Best for reports that require aggregation
Totals, Rows & Columns; Drill-in
Make a table with aggregation including selections
Customization
Widget scripts
Widget scripts
Widget scripts
Blox and widget scripts
Rate this article:
Version history
Last update:
‎03-02-2023 09:47 AM
Updated by:
Contributors