Statistical Analysis of Appointments Report Columns
The following columns are available on the Statistical Analysis of Appointments report:
| Column Name | Description | Data Populates From |
|---|---|---|
| Prac Name | Practice Name | Practice associated with the appointments |
| Loc Name | Service Location Name | Appointments |
| Location SubGrp 1 | Location Subgrouping 1
| Locations Master File |
| Location SubGrp 2 | Location Subgrouping 2
| Locations Master File |
| Res Name | Resource Name | Appointments |
| Event | Event Name | Appointments |
| Appt Date | Appointment Date | Appointments |
| Beg Tm | Begin Time | Appointments |
| End Tm | End Time | Appointments |
| Dur | Duration | Appointments |
| Nbr Sched | Number Scheduled | Calculated |
| Nbr Kept | Number Kept | Number of appointments with Kept status |
| Per Kept | Percentage Kept | Calculated |
| Nbr Canc | Number Cancelled | Number of appointments with Cancelled status |
| Per Canc | Percentage Cancelled | Calculated |
| Nbr NS | Number No Shows | Number of appointments with No Show status |
| Per NS | Percentage No Shows | Calculated |
| Nbr Exp | Number Expected | Number of appointments with Expected status |
| Per Exp | Percentage Expected | Calculated |
| Nbr Pnd | Number Pending | Number of appointments with Pending status |
| Per Pnd | Percentage Pending | Calculated |
| Slots Avail | Appointment Template Slots Available | Appointment Book |
| Slots Booked | Appointment Template Slots Booked | Appointment Book |
| Slots Open | Appointment Template Slots Open | Appointment Book |
| Util Pct | Utilization Percentage | Calculated |
Filter 1
- Appt Date: Include appointments within a date range.
- Deleted: Include/exclude deleted appointments. Select either Only, Exclude (default), or Include All
- Linked Appt: Include/exclude linked appointments. Select either Only, Exclude, or Include All (default)
- Appt Time: Include appointments within a time range.
Filter 2
Use columns to filter data on the report. Column filter options include the following:
- Between
- Equals
- Not Equals
- Greater Than
- Less Than
- Like
Additional Filters
Use additional filters to filter data on the report. Additional filters include the following:
- Events
- Resources
Sorting
Use columns to sort and group data on the report. Column sorting options include the following:
- Ascending
- Descending
- Group By
- Page Break
Totals
Use columns to sub-total and total data on the report. Column total options include the following:
- Sum
- Average
- Count
- Totals