All Articles

Third Next Available Appointment: Calculate and Interpret the Measure

A reproducible appointment-availability worksheet that keeps calendar rules, booking restrictions, and missing observations visible.

Linear Health Editorial Team
Linear Health Editorial Team
Editorial, Linear Health
Published
Two miniature staff at a calendar grid where three open slots are joined by a line and the third is outlined
Measure the third eligible opening from a fixed observation date, with the horizon, booking rules and missing data recorded.

What does the third opening tell you?

A single cancellation can make the next available appointment look unusually close. Looking further into the schedule reduces reliance on that one opening. IHI's historical Whole System Measures specification defines the measure in calendar days, including weekends, and describes collecting provider observations on a consistent weekly reference day. See IHI, 2007, pages 34-35.

Treat it as one piece of your access picture. It does not reveal whether the patient wants that time, whether a referral is ready for scheduling, or whether the patient eventually attends. Keep those questions in the referral-to-appointment conversion measures.

The National Academy of Medicine's scheduling discussion also distinguishes appointment availability from the broader complexity of access. This worksheet does not turn a schedule observation into a clinical judgment about an acceptable wait. See National Academy of Medicine, 2015.

The practical question is narrower: if the defined administrative booking request arrived at the observation time, where would its third eligible opening be?

Freeze the measurement rules before opening the calendar

Give the measurement an owner, usually someone who can inspect both the schedule and its booking restrictions. Ask that owner to write a short specification that another scheduler could apply without verbal explanations.

Start with one visit type and one location. Use the organization's existing approved visit definitions, duration requirements, and provider eligibility. The measurement process should apply those inputs, not invent new clinical matching rules.

The following is an original measurement worksheet. Its fields make the local implementation reproducible; they are not a claim that every scheduling product exposes the same data.

FieldRecord before measurement
ObservationDate, local time, timezone and person or process collecting it
Booking requestVisit type, required duration and approved administrative conditions
Provider scopeNamed provider or explicitly defined provider group
Location and channelSite and the booking channel being tested
Eligible inventoryWhich released slots this request can use
Search horizonLast date inspected and whether the schedule is complete through it
Day conventionCalendar days or a specified business-day calendar
ResultFirst, second and third eligible appointment timestamps
Data statusObserved, insufficient visible openings, or source unavailable
VersionEffective date of the definition and any subsequent change

These details matter when an internal scheduler and an online booking tool expose different inventory. Label the channel rather than assuming both searches describe the same access. The self-scheduling guide covers the patient-facing booking transaction separately.

Use a stated day convention

For this worksheet, calculate calendar days as the third appointment's local date minus the observation's local date. The observation date is day zero. Tomorrow is day one. Weekends and holidays remain in the elapsed calendar count even when the office is closed.

This is a date difference, not completed 24-hour periods. Observing at 4 p.m. on Monday and finding the third opening at 9 a.m. Tuesday produces one calendar day under this convention. Retain the timestamps so an analyst can calculate hours separately if needed.

Definitions are not interchangeable across sources. MGMA's 2025 glossary uses business days for this metric, excluding office-closure days. A value produced under that convention cannot be compared directly with this calendar-day worksheet. See MGMA 2025 DataDive Definitions, page 45.

When joining an external benchmark program, follow its exact specification and label that result. Keep a separate local series if your operational team needs a different convention.

Count distinct bookable appointments, not distinct dates

Sort eligible appointment opportunities by start time. Count the first, second and third, even if two or all three fall on the same day.

For example, three independent, eligible openings later today yield zero calendar days under this worksheet. Three dates are not required. Conversely, three empty blocks do not necessarily create three appointments: the required duration might consume several adjacent blocks, or a room restriction might make them unavailable.

Use the approved scheduling configuration to identify actual booking opportunities. Avoid counting overlapping display fragments as independent inventory. If the same slot appears through two interfaces, count the underlying opportunity once.

A restricted block does not count for a request that cannot use it. A slot reserved for another workflow remains excluded until it is released for this request under the approved rules. Use the provider scheduling logic guide for the wider matching context.

Work through a calendar snapshot

Hypothetical example: a scheduler observes Provider A's calendar at 10 a.m. local time on September 8, 2026. The defined request needs a released 30-minute visit at Site North. The observation date is day zero.

Visible openingMeets this request's approved rules?Count
September 8, 11 a.m., 30 minutesYesFirst
September 8, 3 p.m., 30 minutesYesSecond
September 9, 9 a.m., 15 minutesNo, insufficient durationExcluded
September 10, 9 a.m., 30 minutesYesThird
September 11, 2 p.m., 30 minutesYesLater inventory

The result is September 10 minus September 8, or two calendar days. The first two openings being on the same date does not change their order. The shorter September 9 block does not improve the result because it cannot accommodate the specified appointment.

Now suppose a new cancellation appears at noon on September 8 after the saved observation. It belongs to the next measurement, not a silent correction to the original snapshot. Keep the original evidence and timestamp so the series remains reproducible.

Handle a limited schedule horizon

Suppose Provider C's schedule is visible through September 22, a 14-day horizon, and contains only two eligible openings. Record "third opening not observed within 14 days," along with the two known dates and the horizon.

Do not record zero, 14, or an invented future date as the result. Zero would claim immediate availability; 14 would claim an observed third appointment. Neither is supported.

Also distinguish insufficient inventory from a failed lookup. If the interface stopped loading after September 12, you have incomplete source coverage, not evidence that no appointments exist through September 22.

Assign recovery accordingly. A schedule owner can clarify whether later dates have been released. A technical owner can investigate missing data. The reporting owner keeps the result unavailable until the defined search can be completed.

Extending the horizon can recover a value, but apply the revised horizon consistently to comparable observations. Record the definition change so missing values do not disappear without explanation.

Aggregate providers without changing the question

Continuing the hypothetical example: Provider A has a two-day result, Provider B has eight days, and Provider C has no observed third opening within the common 14-day horizon.

The mean among observed providers is (2 + 8) / 2 = five days, with two of three providers observed. It is not a complete three-provider clinic result. Do not omit Provider C from the coverage statement or substitute zero.

If the saved schedule evidence covers a consistent 30-day horizon at that same observation point, suppose C's third opening is found on day 20. A and B remain at two and eight. The unweighted provider mean is (2 + 8 + 20) / 3 = 10 days. That summary gives each provider equal weight.

If the organization instead chooses weighting by comparable scheduled sessions, disclose the weights. With four equal-length sessions for A, two for B and two for C, the session-weighted mean is:

(2 x 4 + 8 x 2 + 20 x 2) / (4 + 2 + 2) = 8 days.

Both summaries describe the specified calculation. Neither is an average patient's actual wait. Keep the chosen approach stable; do not switch weights because one result looks better.

A pooled search asks another question. If the approved request can use any of these providers, merge their independently bookable opportunities and find the third opening across that pool. Do not calculate it by averaging provider results. A pool could have three openings today across providers while some individual providers have long waits.

Interpret a trend with its coverage record

Repeat the same search at the chosen observation point and preserve changes in visit types, providers, scheduling templates and channel access. Show the individual results before compressing them into a clinic average.

A falling number can reflect additional capacity, a change in released inventory, a new provider, or a change in the measurement definition. Investigate the source before attributing it to automation or staffing.

Review availability alongside actual booking delay, unbooked referrals and unresolved scheduling requests. The referral operations dashboard provides the larger measurement context. A short third-next-available result can coexist with patients who cannot complete booking through their preferred channel.

Choose an investigation and owner: reconcile a restricted slot, inspect a missing provider feed, or review a changed schedule template. The measure should produce a specific operational question rather than an unsupported conclusion about care quality.

For a review of how appointment inventory connects with referral coordination software, bring the observation worksheet and one result your team cannot yet reproduce.

FAQ

Can the third appointment be on the same day as the first two?

Yes. Under this worksheet, count distinct eligible booking opportunities, not dates. Three separate openings later on the observation date produce zero calendar days. Confirm they are independently bookable appointments rather than overlapping fragments of the same time block.

Should weekends count?

They count in this worksheet's calendar-day series. Some external specifications use business days. Match the exact convention when comparing results, and show the definition beside the metric. Never silently change the calculation around holidays or office closures.

What if fewer than three appointments are visible?

Mark the third opening as unobserved within the stated horizon. Record the available openings, last inspected date and source completeness. Extend the search or investigate the source as appropriate. Do not put zero or the horizon length into the numeric result field.

Is this the same as average patient wait time?

No. It is an inventory observation for a defined booking request. Actual patient waits depend on the request, chosen appointment and events before booking. Keep actual request-to-appointment intervals separate, including patients who remain unbooked.

What is a good third-next-available value?

Set an operational aim using the organization's approved service expectations and a consistent baseline. This article provides no universal target or clinical timing rule. Before comparing another practice, verify its visit types, day convention, horizon, provider coverage and aggregation method.

Sources

Linear Health Editorial Team
Linear Health Editorial Team
Editorial, Linear Health
Share this article
Keep reading

Related articles

Stay updated

Get the latest on AI healthcare coordination.