Calendar Utilization Report

Modified on Tue, 20 May at 3:16 PM

This report displays the percentage of time a staff member or resource was booked versus available, based on their scheduled hours.


Things to know:

  • Only staff members with the Service Provider role will appear in this report
  • If the "Enter Clocked Hours Manually instead of Clocking In/Out" hidden setting is enabled, worked hours will be added to the resource filter. The report will track changes made using the "Record Work Hours" button on the scheduler.
  • Blockages created on the schedule are subtracted from the available hours shown in the report. For example, if a staff member is scheduled to work for 8 hours but has a 30-minute blockage, the report will display 7 hours and 30 minutes of available time.
 

To access this report:

  1. Navigate to Dashboard
  2. Select the Reports tab
  3. Under the Staff section, select the Calendar Utilization report

11807504-da825a8f9a5e189b1b6da8bec2e9d63f.png

When the report loads, you can filter by a specific location, staff, resource, and date. You can choose to view utilization by date or location.

If the By Location button is used at the top of the report, you will be able to easily compare metrics across locations and location groupings to see which locations are doing better or worse on that dimension. 

Below the By Location button, you have the option to download the report as a CSV, PDF, or print version. 11185093-8665c18de5acce72bb5a7ec3bdb17f36__1___1_.png

Once you have selected your filters, click on the UPDATE button to generate the desired data.


Report Filters


FilterDescription
LocationThe location where the appointments took place
  • Accounts with One Location: No location filter is shown
  • Accounts with Multiple Locations: The location filter allows you to view data for a specific location or all locations within that account
StaffThe staff member who performed the service during the date range and location selected.
ResourceResources used during the date range and at the location selected
DateThis range will determine the appointments that were booked during the date range selected.


Report Columns


ColumnDescription
Staff / ResourceDisplays the name of the staff member or resource.
Location (Only displayed when filtered 'By Location)Displays the location selected in the location filter
AppointmentsDisplays the total number of appointments scheduled for each staff member during the selected date range.
Booked %

This represents the percentage of available hours that were booked. 


Hours Booked ÷ (Hours Available × Bookings Per Time Slot)) × 100

Unbooked %

This represents the percentage of available hours that were not booked. 


Unbooked Hours ÷ (Hours Available × Bookings Per Time Slot)) × 100

Hours Available 


Represents the total number of hours a staff member or resource is scheduled to work, minus any blocked time on their schedule. Clocked hours are not included in this calculation. 


Total Scheduled Hours – Blocked Time

Bookings Per Time SlotThis refers to the total number of appointments a staff member can handle at the same time. This value is configured on the staff member's profile.

Was this article helpful?

That’s Great!

Thank you for your feedback

Sorry! We couldn't be helpful

Thank you for your feedback

Let us know how can we improve this article!

Select at least one of the reasons
CAPTCHA verification is required.

Feedback sent

We appreciate your effort and will try to fix the article