Pivot Table

version 1.0.0 (Compatible with OutSystems 11)
Published on 04 November 2019 by 
Gonçalo Borrêga
 (0 ratings)

Pivot Table

Allow your business users to explore data through pivot tables, in a drag'n'drop UI similar to that found in popular spreadsheet programs.
Read more

Reactive Web component that allows to easily create an editable Pivot Table that your end users can use to manipulate and look into data.

It wraps PivotTable.js, which implements a pivot table drag'n'drop UI similar to that found in popular spreadsheet programs. You can drag attributes into/out of the row/column areas, and choose a summary function. You can also preconfigure the pivot table and make it readonly, for a static cross-tab like display.

This component allows easily binding your data to the pivot table, through an easy to bind object, converted to JSON. Check the demo module to learn how to use it.

The sample module shows some of the configurations you can make, such as:

  • Define which columns/rows show up by default on the report
  • Define which aggregators are performed (e.g. Count, Sum(Price), List Unique Values)

Features still in development: 

  • Creating "Bins" for grouping dimensions (e.g. Age groups, instead of individual Age data points). Date bins (e.g. Years, Months, Quarters, etc. coming)
  • Predefined Sorting by Totals, Columns or Row aggregators (from NReco PivotTable extensions)
  • Saving pivot table current state allowing you to build a set of custom reports
  • Being notified on which cells get clicked to show drill down detail.

The look and feel of the table is customizable by CSS.
Check PivotTable.js wiki in case you need to go deeper

What’s new (1.0.0)
Reviews (0)