Opened 13 years ago
Closed 9 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 )
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).
Change History (9)
comment:1 Changed 13 years ago by
Component: | General → Dijit |
---|---|
Description: | modified (diff) |
Owner: | anonymous deleted |
comment:2 follow-up: 3 Changed 13 years ago by
comment:3 Changed 13 years ago by
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 13 years ago by
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 13 years ago by
Component: | Dijit → Dojox |
---|---|
Owner: | set to Tom Trenka |
comment:6 Changed 13 years ago by
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 13 years ago by
Milestone: | → 1.3 |
---|
comment:8 Changed 13 years ago by
Description: | modified (diff) |
---|---|
Milestone: | 1.3 → future |
comment:9 Changed 9 years ago by
Component: | Dojox → DojoX Grid |
---|---|
Resolution: | → wontfix |
Status: | new → closed |
Closing this as sjmiles in inactive and if we did have such a new feature it would likely be a separate project in github.
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:
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.