Using GenResultsTable to display a pie chart
Is there any way to display a Pie Chart Report from Quickbase into a new window created by a code page? I am trying to create a button to generate a daily summary report and it was requested to get a ...
Forum Discussion
This is best done with script and the QuickBase API and is a three step process:
(1) Use the API to get the raw data the pie chart would be based on
(2) Use Underscore and jQuery libraries to process the data. This will likely involve filter and aggregating the data using various underscore methods (groupBy, CountBy etc). The data needs to be formatted into a HighChart option objecct (you can see the relevant code on the HighChart's demo page).
(3) Use underscore's template method to take the aggregated data and merge it into a template and display within a QuickBase page.
There are examples somewhere in the forum you can search for. If you get stuck follow up here.
(1) Use the API to get the raw data the pie chart would be based on
(2) Use Underscore and jQuery libraries to process the data. This will likely involve filter and aggregating the data using various underscore methods (groupBy, CountBy etc). The data needs to be formatted into a HighChart option objecct (you can see the relevant code on the HighChart's demo page).
(3) Use underscore's template method to take the aggregated data and merge it into a template and display within a QuickBase page.
There are examples somewhere in the forum you can search for. If you get stuck follow up here.