Pivot Table / Crosstable widget

[guest]

Hi,

This is a feature request: it would be interesting to have a Pivot Table widget in dojo.

Useful links related with this subject:

• Intro: ​http://en.wikipedia.org/wiki/Pivot_table
• Very good java implementation: ​http://www.jidesoft.com/products/pivot.htm
• Javascript (see under Complete Widgets->Pivot Table): ​http://oat.openlinksw.com/

The pivot table should be data-source agnostic. For example, by using a data source interface to define how the data is found (for example, define data inline with the HTML document, or invoke a web service to retrieve it, etc).

[skinner]

Just wanted to mention that the Dojo Foundation actually already does have some simple pivot table code. There's a pivot table plugin in OpenRecord, here:

​http://trac.dojotoolkit.org/openrecord/browser/trunk/source/plugins/PivotTable.js

The OpenRecord pivot table isn't nearly as nice as the OpenLink OAT pivot table, but the OpenRecord pivot table does include a dojo.data binding.

The OAT code is GPL, so we unfortunately we can't use it as a starting point for a Dojo widget. We could use the OpenRecord plugin as a starting point, but it would take a lot of work to turn it into a proper widget.

[guest]

Replying to skinner:

Just wanted to mention that the Dojo Foundation actually already does have some simple pivot table code. There's a pivot table plugin in OpenRecord, here:

​http://trac.dojotoolkit.org/openrecord/browser/trunk/source/plugins/PivotTable.js

This table is OK, but is missing a very important functionality usually found in Pivot Tables: being able to rearrange the rows/columns at will, and drilling down/collapsing data based on some of the fields

[skinner]

That table *does* allow you to rearrange the rows and columns at will, although it does not allow you to drill down or collapse data, and it also does not have a lot of other features you might want.

Here's a link to a demo page with a slightly older version of the same code. The demo tables each have a "Change Layout" button that lets you rearrange the rows and columns: ​http://gumption.org/2004/pivot_table/test_page.html

Feel free to use this code as a starting point for a more full-featured pivot table widget, if you'd like.

[Tom Trenka]

Reassigning to sjmiles; don't know if Grid supports this or not but I seem to recall that it does. sjmiles: is this right, and if so would you close this ticket?

[bill]

Closing this as sjmiles in inactive and if we did have such a new feature it would likely be a separate project in github.