Forum Discussion
_anomDiebolt_
7 years agoQrew Elite
Here is the demo:
Parents ~ List All
https://haversineconsulting.quickbase.com/db/bn4cs5qyy?a=dr&rid=1
Pastie Database
https://haversineconsulting.quickbase.com/db/bgcwm2m4g?a=dr&rid=677
I would have liked to spend a little more time refining this as I think it could be simplified but I am short on time and wanted to get this off my todo list.
Notes:
(1) This demo builds the chart from scratch using the following HighChart example:
Pie Chart Basic
https://www.highcharts.com/demo/pie-basic
I made minimal changes to the HighChart example but every aspect of the chart can be modified to suit your needs.
(2) This demo loads the HighChart library using the requirejs library that QuickBase uses to load many of their libraries:
Parents ~ List All
https://haversineconsulting.quickbase.com/db/bn4cs5qyy?a=dr&rid=1
Pastie Database
https://haversineconsulting.quickbase.com/db/bgcwm2m4g?a=dr&rid=677
I would have liked to spend a little more time refining this as I think it could be simplified but I am short on time and wanted to get this off my todo list.
Notes:
(1) This demo builds the chart from scratch using the following HighChart example:
Pie Chart Basic
https://www.highcharts.com/demo/pie-basic
I made minimal changes to the HighChart example but every aspect of the chart can be modified to suit your needs.
(2) This demo loads the HighChart library using the requirejs library that QuickBase uses to load many of their libraries:
require(["highcharts"], function(Highcharts) {(3) These statements in the code successively transform the semi-colon separated records containing the pill values into the object needed by HighCharts to specify the pie chart data:
// reference to HighChart object
});
var data1 = qdb_data.reduce(function(result, item) {
result.push(...item[0].split(" ; "));
return result;
}, []);
var data2 = {};
data1.forEach(function(val, index) {
data2[val] = data2[val] + 1 || 1;
});
var data3 = [];
for (var key in data2) {
data3.push({name: key, y: data2[key]});
}
QuickBaseCoachD
7 years agoQrew Captain
If you want Dan's solution you will need to contract with Dan to implement it for you. It's an advanced technique.
My summary report solution is the low tech solution that will give you the results, though not in a pie chart.
Alternatively I offered up a solution to make the chart which is native techniques, but you will need to learn about Automations.
My summary report solution is the low tech solution that will give you the results, though not in a pie chart.
Alternatively I offered up a solution to make the chart which is native techniques, but you will need to learn about Automations.