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]});
}
- ChrisNewsome7 years agoQrew CaptainSo I'm a noob at these things, where do i input this formula? How do I make this chart?
- QuickBaseCoachD7 years agoQrew CaptainIf 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. - NickWade7 years agoQrew CadetWhere do you place that IOL formulated attribute so that the DIV is inserted properly on a dashboard? Inside of another report?