Why you no pivot Quick Base?

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=1

Pastie Database
https://haversineconsulting.quickbase.com/db/bgcwm2m4g?a=dr&rid=676

Notes:

(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