Friday 21:00–01:00 walkout rate is 20.0%. The rest of the week sits at 6.6%.
385 ER arrivals in the Friday late window; 77 walked out. At our
$220 per-triage estimate, that's $16.9K
of forgone revenue in the cluster alone, with $11.2K
directly recoverable if the cluster fell to the baseline walkout rate.
The seeded cause in our synthetic data is no-DVM-on-shift weeks (CVT-only Fri 21:00 coverage). The matching
operational fix is a DVM rotation onto the Friday late shift and a written locum-cover plan for the
remaining Fridays. Real-world Cleveland ERs report identical patterns when the locum-cover board has gaps;
VetIQ's 2024 Emergency Volumes Survey puts ER walkout baselines at 4–9% across urban groups.
ER visits (240d)
7,725
walkouts
565
site-wide rate: 7.3%
Fri-late excess
51
walkouts above baseline
recoverable
$11.2K
if cluster → baseline
Walkout heatmap · day-of-week × hour
Top 10 hot cells
| Day | Hour | Visits | Walkouts | Rate |
|---|---|---|---|---|
| Fri | 01:00 | 93 | 24 | 25.8% |
| Fri | 22:00 | 73 | 16 | 21.9% |
| Fri | 23:00 | 81 | 17 | 21.0% |
| Fri | 00:00 | 61 | 11 | 18.0% |
| Fri | 15:00 | 41 | 7 | 17.1% |
| Fri | 05:00 | 47 | 8 | 17.0% |
| Fri | 09:00 | 32 | 5 | 15.6% |
| Mon | 16:00 | 47 | 7 | 14.9% |
| Thu | 03:00 | 36 | 5 | 13.9% |
| Thu | 15:00 | 52 | 7 | 13.5% |
What this looks like in your stack today.
Heatmaps over (day-of-week × hour) aren't in BluWave's standard kit; Vetspire reports
weekly aggregates by site rather than hourly density. The same insight could be hand-built in Looker if you have
a data engineer who can stand up the dimensional grain — typical effort is 2–3 weeks once the warehouse is fed.
The drawer in the lower-right shows the exact
strftime('%w', ...) + strftime('%H', ...)
pivot we used; it ports to Postgres or BigQuery directly.
Cited benchmarks. ER walkout baseline 4–9% from VetIQ 2024 Emergency Volumes Survey across urban specialty/ER groups. Per-triage revenue ($180–$280; we use $220 mid-band) from AAHA 2024 Fee Reference, ER triage exam codes. Press Q for the query this page ran.