Make sense of a messy table

function analyze(rows) {
  const byRegion = {};
  let atRiskValue = 0;

  for (const row of rows) {
    const region = String(row.region || "Other");
    const val = Number(row.value_gbp) || 0;
    if (!byRegion[region]) {
      byRegion[region] = { region, accounts: 0, totalGbp: 0, atRiskGbp: 0 };
    }
    byRegion[region].accounts += 1;
    byRegion[region].totalGbp += val;
    if (String(row.stage) === "at-risk") {
      byRegion[region].atRiskGbp += val;
      atRiskValue += val;
    }
  }

  const table = Object.values(byRegion).sort((a, b) => b.totalGbp - a.totalGbp);
  const chart = table.map((item) => ({ label: item.region, value: item.totalGbp }));

  return {
    answer: "Across all regions, " + atRiskValue + " GBP sits in accounts marked at-risk. " + (table[0] ? table[0].region : "South") + " leads total renewal value at " + (table[0] ? table[0].totalGbp : 0) + " GBP.",
    table,
    chart,
    checkOne: {
      label: "Total GBP in at-risk accounts",
      figure: atRiskValue,
      column: "stage",
      equals: "at-risk",
      mode: "sum",
      sumColumn: "value_gbp"
    }
  };
}