Make sense of a messy table

function analyze(rows) {
  const byProduct = {};
  let unpaidCount = 0;

  for (const row of rows) {
    const prod = String(row.product || "Other");
    const crates = Number(row.crates) || 0;
    if (!byProduct[prod]) {
      byProduct[prod] = { product: prod, orders: 0, totalCrates: 0 };
    }
    byProduct[prod].orders += 1;
    byProduct[prod].totalCrates += crates;
    if (String(row.invoice_status) === "unpaid") {
      unpaidCount += 1;
    }
  }

  const table = Object.values(byProduct).sort((a, b) => b.totalCrates - a.totalCrates);
  const chart = table.map((p) => ({ label: p.product, value: p.totalCrates }));
  const top = table[0] || { product: "None", totalCrates: 0 };

  return {
    answer: top.product + " sold the most volume at " + top.totalCrates + " crates across " + rows.length + " orders, and " + unpaidCount + " invoices are currently marked unpaid.",
    table,
    chart,
    checkOne: {
      label: "Orders with unpaid invoices",
      figure: unpaidCount,
      column: "invoice_status",
      equals: "unpaid",
      mode: "count"
    }
  };
}