result = { /* temporary data structure like: * countries = { * ARG: {: [, , …]}, * AUS: {: [, , …]}, * AUT: {: [, , …]} * } */ var countries = {}; /* temporary data structure like: * countries = { * ARG: {Name: "Argentina", Events: 3, Teams: 12, Rules: 2, Fouls: 2, Fair: 2, Pos: 2, Comm: 2, Total: 2}, * AUS: {Name: "Australia", Events: 3, Teams: 12, Rules: 2, Fouls: 2, Fair: 2, Pos: 2, Comm: 2, Total: 2}, * AUT: {Name: "Austria", Events: 3, Teams: 12, Rules: 2, Fouls: 2, Fair: 2, Pos: 2, Comm: 2, Total: 2}, * } */ var result = {}; var resultTable = [["Code", "Country", "Events", "Teams", "Rules", "Fouls", "Fair", "Pos", "Comm", "Total"]]; // group by countries for (var i = 0; i < teams.length; i++) { if (countries[teams[i].Country] == undefined) { // country does not exist countries[teams[i]["Country"]] = {}; result[teams[i]["Country"]] = {Code: teams[i]["Country"], Name: countryMapping[teams[i]["Country"]]["Name"], Events: 0, Teams: 0}; } if (countries[teams[i].Country][teams[i].Event] == undefined) { // country » event does not exist countries[teams[i].Country][teams[i].Event] = []; result[teams[i].Country]["Events"]++; } countries[teams[i].Country][teams[i].Event].push(teams[i]); result[teams[i].Country]["Teams"]++; } //calculate averages per tournament first for (let [country, events] of Object.entries(countries)) { for (let [event, rows] of Object.entries(events)) { if (rows.length > 1) { var average = {"R: Rules": 0, "R: Fouls": 0, "R: Fair": 0, "R: Pos": 0, "R: Comm": 0}; for (var i = 0; i < rows.length; i++) { average["R: Rules"] += parseFloat(rows[i]["R: Rules"]); average["R: Fouls"] += parseFloat(rows[i]["R: Fouls"]); average["R: Fair"] += parseFloat(rows[i]["R: Fair"]); average["R: Pos"] += parseFloat(rows[i]["R: Pos"]); average["R: Comm"] += parseFloat(rows[i]["R: Comm"]); } average["R: Rules"] = average["R: Rules"]/rows.length; average["R: Fouls"] = average["R: Fouls"]/rows.length; average["R: Fair"] = average["R: Fair"]/rows.length; average["R: Pos"] = average["R: Pos"]/rows.length; average["R: Comm"] = average["R: Comm"]/rows.length; rows.push(average); } } } // calculate the country averages for (let [country, events] of Object.entries(countries)) { var countryAverage = {"Rules": 0, "Fouls": 0, "Fair": 0, "Pos": 0, "Comm": 0}; for (let [event, rows] of Object.entries(events)) { countryAverage["Rules"] += parseFloat(rows[rows.length-1]["R: Rules"]); countryAverage["Fouls"] += parseFloat(rows[rows.length-1]["R: Fouls"]); countryAverage["Fair"] += parseFloat(rows[rows.length-1]["R: Fair"]); countryAverage["Pos"] += parseFloat(rows[rows.length-1]["R: Pos"]); countryAverage["Comm"] += parseFloat(rows[rows.length-1]["R: Comm"]); } result[country]["Rules"] = Math.round(countryAverage["Rules"]/Object.entries(events).length * 100)/100; result[country]["Fouls"] = Math.round(countryAverage["Fouls"]/Object.entries(events).length * 100)/100; result[country]["Fair"] = Math.round(countryAverage["Fair"]/Object.entries(events).length * 100)/100; result[country]["Pos"] = Math.round(countryAverage["Pos"]/Object.entries(events).length * 100)/100; result[country]["Comm"] = Math.round(countryAverage["Comm"]/Object.entries(events).length * 100)/100; result[country]["Total"] = Math.round((result[country]["Rules"] + result[country]["Fouls"] + result[country]["Fair"] + result[country]["Pos"] + result[country]["Comm"]) * 100)/100; } // convert to table Object.keys(result).sort().forEach(function(country) { resultTable.push([country,result[country]["Name"],result[country]["Events"],result[country]["Teams"],result[country]["Rules"],result[country]["Fouls"],result[country]["Fair"],result[country]["Pos"],result[country]["Comm"],result[country]["Total"]]); }); return resultTable; }