Opened 12 years ago

Closed 8 years ago

#4587 closed enhancement (wontfix)

Pivot Table / Crosstable widget

Reported by: guest Owned by: sjmiles
Priority: high Milestone: future
Component: DojoX Grid Version: 0.9
Keywords: Cc:
Blocked By: Blocking:

Description (last modified by sjmiles)

Hi,

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

Useful links related with this subject:

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).

Change History (9)

comment:1 Changed 12 years ago by skinner

Component: GeneralDijit
Description: modified (diff)
Owner: anonymous deleted

comment:2 Changed 12 years ago by 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.

comment:3 in reply to:  2 Changed 12 years ago by 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

comment:4 Changed 12 years ago by 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.

comment:5 Changed 12 years ago by bill

Component: DijitDojox
Owner: set to Tom Trenka

comment:6 Changed 12 years ago by Tom Trenka

Owner: changed from Tom Trenka to sjmiles

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?

comment:7 Changed 11 years ago by dylan

Milestone: 1.3

comment:8 Changed 11 years ago by sjmiles

Description: modified (diff)
Milestone: 1.3future

comment:9 Changed 8 years ago by bill

Component: DojoxDojoX Grid
Resolution: wontfix
Status: newclosed

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

Note: See TracTickets for help on using tickets.