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
I am running into the same issue as the OP. I have a Pie Chart displayed just fine in QB. I did not create the Pie Chart, someone else did. I am being tasked with getting it to show up in another site (WordPress) using the API to call it.
Below is what my Pie Chart report URL looks like (without my domain).
/db/boquead?a=q&qid=160&nv=1&v0=314&ifv=1
Below is the URL I am using to get all the JavaScript that would help me recreate this Pie Chart in my site.
/db/boquead?a=API_GenResultsTable&qid=160&nv=1&v0=314&jsa=1
What I am seeing is the first URL that displays the report shows me 14 items in my legend and 14 corresponding slices of the pie chart. The JavaScript data that gets returned does not have the legend items with their names, and it does not contain all of the individual slices of data. I get 125 items in my array, many of them are empty, some are $0, and I am not getting any names. From the data that gets returned, I would not be able to recreate this pie chart report, as I am missing the legend items and some of the values.
Am I missing something with my approach? How can I get the legend items? Which is what each slice of the pie represents?
Thanks for any help.
Below is what my Pie Chart report URL looks like (without my domain).
/db/boquead?a=q&qid=160&nv=1&v0=314&ifv=1
Below is the URL I am using to get all the JavaScript that would help me recreate this Pie Chart in my site.
/db/boquead?a=API_GenResultsTable&qid=160&nv=1&v0=314&jsa=1
What I am seeing is the first URL that displays the report shows me 14 items in my legend and 14 corresponding slices of the pie chart. The JavaScript data that gets returned does not have the legend items with their names, and it does not contain all of the individual slices of data. I get 125 items in my array, many of them are empty, some are $0, and I am not getting any names. From the data that gets returned, I would not be able to recreate this pie chart report, as I am missing the legend items and some of the values.
Am I missing something with my approach? How can I get the legend items? Which is what each slice of the pie represents?
Thanks for any help.