The formula is one line: no-shows divided by scheduled, times 100. The work is in the inputs. We walk through three practice types side by side, with the exact counts to include and exclude, the period to use, and what the resulting number tells you.
Reference: MGMA 2024 DataDive methodology.
The formula looks trivial. What makes it produce meaningful or misleading numbers is the inputs.
For the numerator (no-shows), only count patients who failed to appear AND did not make contact before the appointment. Do not count patients who called or texted to cancel, even if the notice was too short to backfill. Do not count patients who proactively rescheduled. Do not count patients who arrived and were sent home because of operational issues on your side (overbooking, room shortage, provider running late beyond clinic acceptability).
For the denominator (scheduled), count all scheduled appointments in the measurement period. Include same-day add-ons that were entered into the schedule. Include walk-ins that were assigned a slot. Do not include slots that were held open and never booked. Do not include slots that were blocked off for provider PTO or admin time.
Track the rate over a discrete period. Most practices use a calendar month for routine operational tracking and a rolling 12-month for benchmark comparisons. Sub-segment the rate by provider, by day-of-week, by hour-of-day, and by payer to find the concentrations that operational intervention can target.
Dr. Wakefield runs a solo family medicine practice with a single MA and a front-desk coordinator. The schedule blocks 22 patient slots per day (Mon-Thu, 10 hours per day with a 1-hour lunch and a 30-minute admin buffer). March 2026 has 22 working days for this practice (one day closed for personal leave, one for CME). Total scheduled slots: 22 days x 22 slots = 484.
During March, the practice records: 412 patients attended, 56 patients no-showed (no contact, did not appear), 11 patients cancelled with same-day notice (cancelled by phone or portal the morning of), 5 patients rescheduled in advance.
What goes into the formula: numerator is 56 (only the true no-shows). Denominator is 484 (all scheduled slots). The 11 same-day cancels are not no-shows. The 5 rescheduled are not no-shows. The arithmetic: 56 / 484 x 100 = 11.6 percent.
That is materially below the MGMA 2024 primary care median of 19 percent, putting Dr. Wakefield in the top quartile. The same-day cancel rate of 2.3 percent (11 / 484) is also low. Most likely explanation: established commercial-heavy patient panel, consistent SMS reminders, short booking horizons. The practice should track over a rolling 3 to 6 months to confirm March 2026 was not an outlier month.
A 5-provider dental practice (3 GP dentists, 1 periodontist, 1 hygiene supervisor) running 5 operatories. Q1 2026 (Jan to Mar) has 64 working days. The schedule allocates 6 patient slots per operatory per day across hygiene and restorative. Total Q1 scheduled slots: 64 days x 5 operatories x 6 slots = 1,920.
Q1 record: 1,488 patients attended, 348 no-shows, 64 same-day cancels, 20 reschedules. Practice manager initially reported a no-show rate of 432 / 1,920 = 22.5 percent by including the same-day cancels with no-shows.
Correctly applying the formula: 348 / 1,920 x 100 = 18.1 percent. This is at the high end of the JADA 2023 dental band (15 to 25 percent). Sub-segmenting reveals the problem: hygiene appointments run 22 percent no-show, restorative runs 13 percent. Hygiene is the lever. The fix: text reminder cadence specific to hygiene visits (which are lower-perceived-priority for many patients than restorative work), card-on-file for hygiene scheduling, and a same-day hygiene waitlist.
The separate same-day cancel rate of 64 / 1,920 = 3.3 percent is normal for dental. The 20 reschedules are healthy patient behaviour and not a problem.
A multi-specialty group with 5 primary care providers, 3 cardiologists, 2 endocrinologists, 1 dermatologist, and 1 podiatrist. FY 2025 totals: 51,840 scheduled appointments, 8,294 no-shows, 1,866 same-day cancels, 720 reschedules. Headline rate: 8,294 / 51,840 = 16.0 percent.
But the headline obscures meaningful variance by provider type. Sub-segmented: primary care 19.4 percent (n = 26,400 slots), cardiology 11.2 percent (n = 12,672 slots), endocrinology 13.7 percent (n = 8,448 slots), dermatology 9.5 percent (n = 2,640 slots), podiatry 14.8 percent (n = 1,680 slots). The aggregate 16 percent is a weighted average of materially different specialty rates.
Further sub-segmentation by payer reveals: commercial 13.8 percent, Medicare 11.9 percent, Medicaid 28.7 percent, self-pay 19.2 percent. The Medicaid sub-cohort is dragging the aggregate up and is concentrated in primary care.
The right operational response is not a single intervention applied uniformly across the group. It is targeted: SMS reminder cadence intensification on Medicaid primary care, rideshare integration for the high-no-show Medicaid PCP cohort, telehealth shift for cardiology and endocrinology follow-ups (where the rate is already lower but telehealth can drop it further), card-on-file for dermatology cosmetic visits. See the Medicaid no-show folio, specialist folio, and telehealth folio.
| Practice | Scheduled | No-shows | Rate | vs benchmark |
|---|---|---|---|---|
| Solo PCP (March 2026) | 484 | 56 | 11.6% | Top quartile |
| 5-provider dental (Q1) | 1,920 | 348 | 18.1% | Mid-band |
| 12-provider multi-spec (FY) | 51,840 | 8,294 | 16.0% | Weighted |
The takeaway is not that one practice is doing better than another. The 11.6 percent solo PCP is correctly compared to the 19 percent MGMA primary care median; the 18.1 percent dental is correctly compared to the 15 to 25 percent JADA dental band; the 16.0 percent multi-specialty is a blended average that requires sub-segmentation to be operationally useful. Apply the same formula but use the right benchmark for your context.
Register entries verified 2026-04-28