Workflow · Finance close · Opening soon

Clinic patient no-show rate

See each provider’s no show rate for the last 8 weeks in one table. Add a status that flags providers whose no show rate runs high.

Book a demo

Someone typed

“show each provider for the last 8 weeks with appointments booked, no-shows, no-show rate, and status; status is Agrees when no-show rate is 20% or less, otherwise High no-show rate”

The agent read it as

Show each provider for the last 8 weeks with appointments booked, no-shows, no-show rate, and status; status is Agrees when no-show rate is 20% or less, otherwise High no-show rate, excluding cancelled appointments.

What the agent built

1 step, each one an ordinary Mammoth step you can open and change.

File

Clinic appointments export

CSV export · 45 rows

Step

Count provider no-shows

Step 1

Result

Provider No-show Rates

5 rows · 2 flagged

Schedule

Runs when you say

Proposed

File
Clinic appointments export
CSV export · 45 rows
Step
Count provider no-shows
Step 1
Result
Provider No-show Rates
5 rows · 2 flagged
Schedule
Runs when you say
Proposed

Checked on the sample files: every step ran, 5 rows came out.

Download Clinic appointments export sample (45 rows)Excel: Scheduling workbook > Appointments sheet > Export as CSV

What you get back

The result of that run, the rows to look at first.

Provider No-show RatesSample data5 rows

3 agrees2 high no-show rate

Provider	Appointments booked	No-shows	No-show rate	Status
Dr. Ben Wallace	8	2	25	High no-show rate
Dr. Emily Zhao	8	3	37.5	High no-show rate
Dr. Ana Patel	8	1	12.5	Agrees
Dr. Carla Nguyen	8	0	0	Agrees
Dr. Daniel Kim	7	1	14.3	Agrees

5 rows in the result. Sample data: illustrative figures, not business results.

How do you calculate patient no show rate by provider?

Export your appointments from Excel, then filter to the last 8 weeks and exclude cancelled appointments. Count booked appointments and no-shows for each provider, then calculate no show rate as no-shows divided by booked appointments as a percent. Add a Status column that says Agrees when the no show rate is 20% or less, otherwise High no show rate.

How it works

How to use the Provider No-show Rates workflow

1Get early accessWe invite people in small batches, job by job. You'll land on this workflow, already built and checked on the sample files.
2Swap in your exportsUpload your own files as they come out of your tools. The agent checks the workflow on your rows.
3Change it in words, then turn it onSay what to change and see the new result before anything saves. Then choose when it runs.

Provider No-show Rates: questions

What export should you use?

Use the Excel export that includes provider, appointment status, and appointment date. The workflow reads the rows from that file and uses them to count bookings and no-shows.

What happens to rows that do not match the rules?

Rows outside the last 8 weeks, and cancelled appointments, are left out of the result. Only rows that match the rules are used in the counts and rate.

How do you change the rules?

Edit the rules in words, for example change the date window, the status to exclude, or the threshold for the Status column. The workflow then applies the updated rules to the exported rows.