cancel
Showing results for 
Search instead for 
Did you mean: 
Harland-Dear
Canine II

Reporting on waiting times

Is there a report I can use to do an audit on patient waiting times? How long patient has waited on average per clinician for each month? The purpose of this audit is to establish how long patients wait before they go into surgery (dentist running late, on time, etc)

Would someone be able to assist

0 Kudos
Reply
2 Replies
Alison_Daniels
CS Dental Employee
CS Dental Employee

Re: Reporting on waiting times

Good Afternoon
Unfortunately there isn't a report on waiting time or a way to calculate it in R4.
Kind regards
Aliso
Alison_Daniels
CS Dental Employee
CS Dental Employee

Re: Reporting on waiting times

Good Morning

After some research I have been advised by a colleague that you can create a bespoke report to show average waiting time.

To create a report to show average waiting time by performer

  1. Open Report Manager
  2. Highlight ‘Reports not in a category’
  3. Click ‘New Report’ then ‘Start’
  4. Click the ellipsis to create a new query
  5. Click ‘New Query’ then ‘Start’
  6. Highlight ‘Appointments’ then ‘Next’
  7. Tick ‘that have certain attributes’ then ‘Specify Attributes’
  8. Add ‘Date’ to the ‘Criteria’ window
  9. Amend the ‘operator’ column to ‘is later than or equal to’ tick the Ask box then click ‘OK’ and amend the question to say ‘please specify the start date’
  10. Add ‘Date’ again to the ‘Criteria’ window
  11. Amend the ‘operator’ column to ‘is earlier than or equal to’ tick the Ask box then click ‘OK’ and amend the question to say ‘please specify the end date’ the click
  12. Click ‘OK’
  13. Then tick the box next to ‘that have been completed’
  14. Click ‘Finish’ then save the query
  15. Select the query just made then click ‘Next’
  16. Click ‘Report Layout’
  17. Click on ‘click here to edit report properties’ (in blue)
  18. Select the from the Fields list the following; Treatment Provider, Date,  and from the Lead Times Visit time, Waiting Time and Surgery Time
  19. For the last 3 tick the boxes to show Total and Average
  20. Click ‘OK’ then ‘Finish’ and finally save the report.

I hope this gives you the information you require.

Kind regards

Alison