Using GenResultsTable to display a pie chart

  • 0
  • 1
  • Question
  • Updated 10 months ago
  • Answered
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 Pie Chart of the data. I know Highcharts could be used as an external tool but is there a way to just display a Pie Chart that is currently in Quickbase already?
Photo of William Marrone

William Marrone

  • 310 Points 250 badge 2x thumb

Posted 10 months ago

  • 0
  • 1
Photo of Dan

Dan

  • 140 Points 100 badge 2x thumb
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.