Why you no pivot Quick Base?

>Why you no pivot Quick Base?

Because the feature did not clear the threshold decision of being implemented. You could put in a suggestion over at UserVoice and cross your fingers or empower yourself to implement it yourself using script. I will help you if you are reluctant to try. It is easy.

Nevertheless it is simple to implement using JavaScript using any of the available pivot table implementations. For example:

jQuery Plugin - PivotTable.js
https://pivottable.js.org/examples/

Simple Example:


https://pivottable.js.org/examples/simple.html

If you look at the code for this example you will see that the raw data for the pivot table has been already been grouped. In QuickBase you would have to grab the table data from the API and group it using Underscore's _.groupBy() method. 

This is a simple task and I might create a demo over the weekend.

While those who don't know quickbase use excel at my work and create pivot tables, I use QuickBase for that and much more. QuickBase has summary reports, it has relationships, summary fields, and more, With all these ammunition, I can do Pivot and more. QuickBase is the BEST!

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