Pivot Table

Version 1.0.0 (OutSystems 11)
Published on 4 Nov (9 days ago) by 
Created on 4 Nov (9 days ago)
Details
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

Reviews (0)
Category
UI & Widgets, Reporting
Support Options
This component is not supported by OutSystems. You may use the discussion forums to leave suggestions or obtain best-effort support from the community, including from Gonçalo Borrêga who created this component.
Dependencies
Pivot Table has no dependencies.
Requirements
Platform:
11.0.606.0
Database:
All
Stack:
.NET
Component Consumers
No consumers yet.
Weekly Downloads