Why you no pivot Quick Base?
The concept of the PivotTable in Excel seems so simple and novice. It is one of the first tools many people go to when they want to report out on data or try to learn something from data. PivotTable, ...
Forum Discussion
>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.
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.
- Please share if you do Dan. I find myself going back to excel for pivot tables and pivot charts. The goal with using Quick Base in our organization was to minimize the number of application platform used and automate work as much as possible, but that has been a no-go in regards to reporting using pivot tables and charts.
