Make sense of a messy table

function analyze(rows) {
  const byClinic = {};
  let smsYesTotal = 0;
  let smsYesNoShow = 0;
  let smsNoTotal = 0;
  let smsNoNoShow = 0;

  for (const row of rows) {
    const clinic = String(row.clinic || "Unknown");
    if (!byClinic[clinic]) {
      byClinic[clinic] = { clinic, bookings: 0, noShows: 0 };
    }
    byClinic[clinic].bookings += 1;
    const isNoShow = String(row.outcome) === "no-show";
    if (isNoShow) byClinic[clinic].noShows += 1;

    if (String(row.sms_sent) === "yes") {
      smsYesTotal += 1;
      if (isNoShow) smsYesNoShow += 1;
    } else {
      smsNoTotal += 1;
      if (isNoShow) smsNoNoShow += 1;
    }
  }

  const table = Object.values(byClinic).sort((a, b) => b.noShows - a.noShows);
  const chart = table.map((item) => ({ label: item.clinic, value: item.noShows }));
  const top = table[0] || { clinic: "None", noShows: 0 };

  return {
    answer: top.clinic + " had the most no-shows (" + top.noShows + " of " + rows.length + " total bookings). Bookings without an SMS reminder accounted for " + smsNoNoShow + " of " + smsNoTotal + " no-shows, compared with " + smsYesNoShow + " of " + smsYesTotal + " when an SMS was sent.",
    table,
    chart,
    checkOne: {
      label: "Total no-shows across all clinics",
      figure: smsYesNoShow + smsNoNoShow,
      column: "outcome",
      equals: "no-show",
      mode: "count"
    }
  };
}