Sorry for the delay in posting a pivot table demo but I had a heck of a time finding an appropriate image macro for the demo. So here goes:
Unknown Comic Image
As many of you may know I am deep into math and I often use QuickBase to organize my work. I do a lot of work with something called
Sparse Matrices which is basically a matrix with a lot of zeroes. You can think of a sparse matrix as a spreadsheet where the majority of the cells are empty or zero.
Sparse Matrices arise naturally in science and engineering where entities of some type interact with a neighbor entities but not with distant entities.
Sparse Matrices are so important that researchers from various organizations have compiled registries of
Sparse Matrices for research and testing purposes.
And it goes without a lot of explanation that a great way to view these
Sparse Matrix registries is to produce a
pivot table organized by the contributor's
Group and the
Year the contribution was made.
So here is the demo:
Sparse Matrices Pivot Table (Group x Year)https://haversineconsulting.quickbase.com/db/bn38wdgzy?a=dr&rid=1Pastie Databasehttps://haversineconsulting.quickbase.com/db/bgcwm2m4g?a=dr&rid=676Notes:(1) This demo uses the jQuery
pivottable plugin:
https://pivottable.js.org/examples/(2) The
pivottable plugin was modified slightly to prevent it from loading as an AMD module and as modified hosted from a QuickBase code page.
(3) I tried to make my code as short as possible so that it could be adopted by other users with minimal changes. Other than the customary parameters for the dbid's, apptoken, and two code page URLs, the only parameters you would have to change in the code are the clist and and the related parent fid:
query: '{14.EX.${kRid}}',
clist: "7.12",
(4) I implemented my pivot table through the view page of a parent table. If you want your pivot table to show up elsewhere it would be a simple matter of repackaging the same basic code.
(5) My example uses the new ES6
backticks:
query: '{14.EX.${kRid}}',
and
shortcut properties:
$.ajaxSetup({data: {apptoken}});
(6) The plugin
pivottable has an extensive set of features. You can aggregate on any quantity you can calculate, generate clickable drill-down pivot tables or create pivot charts with graphics and controls.
(7) You can think of that
tic-tac-toe board on top of the
Unknown Comic's paper bag as a sparse matrix!
As always feel free to contact me off-world using the information in my profile if you need individual assistance with your pivot table project:
https://getsatisfaction.com/people/dandiebolt