Draft reference — content review pending

Appointment No-Show Rate

The percentage of eligible scheduled appointments where the scheduled attendee did not attend and did not cancel within the defined policy window.

Plan my KPIs

Business question

What share of eligible scheduled appointments is recorded as a no-show under the agreed attendance policy?

Formula

Appointment no-show rate = eligible scheduled appointments recorded as no-shows under the policy ÷ eligible scheduled appointments × 100.

(Eligible policy-defined no-shows / Eligible scheduled appointments) × 100

Calculation notes

Define the policy window, appointment eligibility, attendance event, rescheduling treatment, walk-in treatment, and the handling of provider-caused cancellations before comparing periods.

Edge-case guidance

Do not classify a late cancellation as a no-show unless the documented policy does so. Keep emergency, overbooked, and documented exception categories separate and aggregate.

Required data

InputTypeStatusAvailable source hints
Eligible policy-defined no-showsAggregate count of eligible scheduled appointments classified as no-shows under the documented policy.NumberRequiredAppointment system · Excel · Google Sheets · Manual records
Eligible scheduled appointmentsAggregate count of scheduled appointments included after applying the agreed eligibility and period rules.NumberRequiredAppointment system · Excel · Google Sheets · Manual records

Interpretation

Use this aggregate operational measure to understand unused scheduled capacity. Keep late cancellations, rescheduled appointments, walk-ins, provider-caused cancellations, and documented scheduling exceptions separate.

Caution

Use aggregate records only. Do not include names, individual record identifiers, or other personal health information. Implementation must follow applicable privacy, healthcare, and insurance requirements. Exclude records that cannot be classified consistently.

Implementation recommendation

Agree on aggregate status definitions and the policy window with scheduling owners, then annotate changes in booking policy and capacity.

Target guidance

Set a context-specific target for appointment no-show rate from comparable historical periods, then adjust it for scheduling policy, operating capacity, seasonality, service mix, and data quality. Review the target with the accountable operations owner; reducing it through punitive or exclusionary scheduling practices may distort access and the measure.

Related metrics