Capacity · wait by day-of-week

mean check-in wait per (hospital × DOW) · 240d window
READ-ONLY · NEVER-SEND · TCPA-CLEAN
last sync: 2026-06-01 17:47 UTC
reset / focuses this bar · Q toggles SQL · ? all shortcuts
Pittsburgh Tuesday wait is 61 min. Every other day this site sits at roughly 22 min.
That's a 39.5-minute gap on Tuesdays — concentrated at the 11:00–12:00 check-in band. The synth cause is a template default that over-books the Tuesday 11am slot. Real-world Pittsburgh specialty hospitals see this same pattern after a board-certified hire whose Tuesday block was replicated from a different rotation. The fix is redistribute the block across Wednesday and Thursday and free a 30-minute mid-morning gap; that recovers roughly $24.1K of revenue across the window at a conservative 5% bail-rate × $385 specialty consult fee.
network avg wait
29m
visit-weighted
worst (hospital, DOW)
61m
Riverbend Specialty Pittsburgh · Tue
Pittsburgh Tue gap
+39.5m
vs Pittsburgh mean
recoverable revenue
$24.1K
if Pgh Tue → Pgh mean

Wait minutes by hospital × day-of-week

Hospital SunMonTueWedThuFriSat
Riverbend Emergency Cleveland 32m
926
31m
935
32m
926
32m
939
31m
928
32m
903
31m
893
Riverbend Specialty Akron 21m
49
22m
185
21m
186
21m
186
21m
191
21m
164
22m
41
Riverbend Specialty Pittsburgh Tue outlier 22m
502
21m
1,260
61m
1,251
21m
1,258
21m
1,270
22m
1,241
22m
485
Riverbend Urgent Care Columbus 29m
1,335
28m
1,333
28m
1,315
29m
1,316
29m
1,317
28m
1,277
29m
1,303

Per-hospital biggest-day gap (worst DOW vs own mean)

Hospital Worst day That day's wait Site mean Gap Visits that day
Riverbend Specialty Pittsburgh Tue 61m 27m +34m 1,251
Riverbend Specialty Akron Mon 22m 21m +1m 185
Riverbend Emergency Cleveland Sun 32m 32m +0m 926
Riverbend Urgent Care Columbus Sun 29m 29m +0m 1,335
What this looks like in your stack today. Wait-time-by-day-of-week is a basic operational chart but it lives nowhere in most PMSes by default. Cornerstone and AVImark have wait-tracking fields that are inconsistently populated; ezyVet exposes them via API only. BluWave/Reflexion publish weekly aggregates that wash out day-of-week patterns. The query here joins visits.wait_minutes against strftime('%w', visit_date) and averages by (hospital × day-of-week) — port it to your own warehouse in an afternoon.

Cited context. The specialty-consult fee ($385) is anchored to the AAHA Veterinary Fee Reference (11th ed.), the exam line alone. The 5% bail-rate at long waits is a Central Uplift estimate (no public veterinary bail-rate benchmark exists). Measure-only: the recommendation is a scheduling-template change the operator makes. Press Q for the query.