Created on 19 December 2015
icon_unfollowing
Login to follow
pivot-table

Pivot Table - Traditional

Stable version 2.0.4 (Compatible with OutSystems 11)
Other versions available for 10 and Older
Uploaded on 10 November 2019 by 
Gonçalo Borrêga
pivot-table

Pivot Table - Traditional

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. Traditional Web.
Read more

PivotTable.js 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 makes it very simple to use the library (PivotTable.js), using as datasource either data on the screen inside a TableRecord, or accessed from a REST API you create with the platform.

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

  • Creating "Bins" for grouping dimensions (e.g. Age groups, instead of individual Age data points). Date bins (e.g. Years, Months, Quarters, etc. coming)
  • Define which columns/rows show up by default on the report
  • Define which aggregators are performed (e.g. Count, Sum(Price), List Unique Values)
  • 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



Release notes (2.0.4)
  • Fixed issue with the new way to add extended configurations to RendererOptions that include text JSON objects (for the new chart or sorting sections)
Reviews (3)
by 
2019-11-05
in version 2.0.2
nice tool..
but I don't know how to use the function.
I really hope the documentation is there.
by 
2019-07-18
in version 2.0.1
Very easy to use.
by 
2018-12-20
in version 2.0.1
Good tool. The REST version example is not complete, but you can look for the "parliament" example to see all.
As a suggestion, good idea if can show/hide the total column/line. Some times we do not want to totalize the column/line.
Great tool!
Category
User interface, List & tables
Tags
Support options
This asset is not supported by OutSystems. You may use the discussion forums to leave suggestions or obtain best-effort support from the community, including from  who created this asset.
Dependencies
Pivot Table - Traditional has no dependencies.
Application Objects
Pivot Table - Traditional has 1 AOs.
Team
Compatible with
Version 11
Database:
All
Asset consumers
No consumers yet.
Weekly downloads