In a practice where the doctor's time is the constraint, an empty exam lane is unrecoverable revenue. Every open slot, every no-show, every same-day cancel is a 20- or 30-minute block of clinical capacity that can't be sold again — and it cascades downstream, because an exam that never happens is also an Rx that never gets written and eyewear that never gets dispensed. This dashboard turns the schedule into accountability: how full the lanes run, where slots go empty, and where attendance leaks.
What this dashboard answers
The Lane Throughput page answers the office manager's first question: how productive is the schedule? It shows chair/lane utilization, exams completed, slot fill rate, and exams per provider-day, with utilization trended by date, ranked by location, and completed exams broken out by day of week so the slow days are obvious. The Schedule Efficiency page focuses on leakage — slot fill rate, no-show/same-day-cancel rate, a no-show bar by provider, and a stacked breakdown of every slot's outcome (Completed, No-Show, Same-Day Cancel, Open/Unbooked) by location — plus a per-provider table that ties it all together.
The metrics that matter
Utilization is booked minutes over available minutes, and slot fill is booked slots over total slots — both ratios, both computed as a sum over a sum so a long appointment doesn't distort the rate. No-show rate is intentionally taken over booked slots, not over all slots, so it measures attendance on the appointments that were actually made. Exams per provider-day normalizes throughput against days actually worked, which is the fairest way to compare a part-time associate to a full-time owner.
Why the data is trapped across the systems
The schedule, the slot template, and the appointment outcomes all live in the EHR/PM scheduler — RevolutionEHR, Crystal PM, Compulink, Acuitas (Ocuco), My Vision Express. The raw scheduling export is rich, but it's a transactional log, not a report: turning it into utilization requires defining available lane minutes, classifying each slot's outcome, and counting distinct provider-days, none of which the scheduler does for you. So most practices feel the capacity problem — packed some days, empty others — without ever quantifying it, because the report that would expose it doesn't exist out of the box.
How to read it
Read utilization and fill rate first to size the opportunity, then read no-show rate by provider and the day-of-week pattern to find where it concentrates. Empty slots and no-shows are different problems: empty slots are a demand or scheduling-template issue, no-shows are a reminder and engagement issue, and same-day cancels are nearly as costly as no-shows because there's no time to backfill the lane. The sample uses fully synthetic scheduling data, so no patient information appears in the report.
Metrics it tracks
| Metric | What it means |
|---|---|
| Chair/Lane Utilization Rate | Booked exam minutes divided by total available lane minutes (a SUM-over-SUM ratio). |
| Exams Completed | Count of exam slots where the visit was completed. |
| Slot Fill Rate | Booked slots divided by total schedulable slots (SUM over SUM). |
| No-Show / Same-Day-Cancel Rate | No-show and same-day-cancel slots divided by booked slots (SUM over SUM). |
| Available Slots | Count of all schedulable exam slots in the period. |
| Exams per Provider-Day | Completed exams divided by distinct provider-days worked (SUM over SUM). |
Used by: Office managers and owner-ODs managing exam-lane throughput
Frequently asked questions
What's a good chair or lane utilization rate for an optometry practice?
Practices generally want lanes booked well into the high range with a little headroom for buffer and emergencies; running at or near full all day usually means demand is being turned away, while a low rate means capacity is being wasted. The value of tracking it is the spread by location, provider, and day — the schedule's actual shape, not a single benchmark.
Why measure no-show rate over booked slots instead of all slots?
Because a no-show is a failure of an appointment that was actually made. Dividing no-shows by booked slots measures attendance reliability, while dividing by all slots would blend in empty slots, which are a separate demand problem. Keeping the two apart tells you whether to fix scheduling or fix reminders.
Can I build this on my own scheduling data?
Yes. Export your appointment and slot data from your EHR/PM scheduler and use this as a template — we model it into a Power BI report you open in Power BI Desktop. The sample uses synthetic data, so there's no patient information here.
Build this report on your own data
Clone this Optometry & optical template — describe it and we’ll generate sample data so you can try it free, or upload your own export. You get a fully modeled, branded Power BI project that opens in Power BI Desktop.
Use this as a template →