Separate Multi-Select Text Fields on a Pie Chart

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:

  require(["highcharts"], function(Highcharts) {
    // reference to HighChart object 
  });

(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:

      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]});
      }