Orchestra Business Intelligence User Console Basics : Business Intelligence Calculations : Appointments Arrival
  

Appointments Arrival

The following sections are available for the creation of Appointments Arrival reports, together with the General sections: Branch, Date, and Time.
Resource
Name
Description
Resource Name
The resource names.
Service
Name
Description
Service Name
The Service names.
Arrivals
Name
Description
Arrival status
Here are the different options from table dim_arrival_status.
Measures/Metrics
Name
Description
Appointment WT, Average
The average Appointment waiting time.
Appointment WR, Max
The longest Appointment waiting time.
Transaction Time, Average
The average transaction time.
Waiting Time, Average
This is the average waiting time.
Walking Time, Average
This is the average walking time.
WrapupTime, Average
This is the average wrap-up time.
Bookings
Counts the number of Appointments based on booked date and time.
Appointment starts
Counts the number of Appointment starts.
Appointment ends
Counts the number of Appointment ends.
Cancellations
Counts the number of cancellations.
Changes
Counts the number of changes.
No Shows
The number of called Appointments that were No Shows.
Appointment WR, Total
The total Appointment waiting time.
Transaction Time, Total
The total transaction time.
Waiting Time, Total
The total waiting time.
Walking Time, Total
The total walking time.
Wrapup Time, Total
The total wrap-up time.
Appointment Length, Average
The average time booked for the Appointments
Called before time
The number of Customers that were called before the Appointment time.
Days in Advance, Average
The average time in days between the booking date and the Appointment date.
Days in Advance, Max
The longest time between a booking date and an Appointment date.
AWTD 1(0–2 min)
The number of Customers with an Appointment waiting time from and including 0 but less than 2 minutes (The time interval for the Appointment waiting time is two minutes because the Appointment waiting time is usually very short).
AWTD 2 (2–4 min)
The number of Customers with an Appointment waiting time from and including 2 but less than 4 minutes.
AWTD 3 (4–6 min)
The number of Customers with an Appointment waiting time from and including 4 but less than 6 minutes.
AWTD 4 (6–8 min)
The number of Customers with an Appointment waiting time from and including 6 but less than 8 minutes.
AWTD 5 (8–10 min)
The number of Customers with an Appointment waiting time from and including 8 but less than 10 minutes.
AWTD 6 (10- min)
The number of Customers with a waiting time from and including 10 minutes.
TTD 1 (0–3 min)
The number of Customers with a transaction time from and including 0 but less than 3 minutes.
TTD 2 (3–6 min)
The number of Customers with a transaction time from and including 3 but less than 6 minutes.
TTD 3 (6–9 min)
The number of Customers with a transaction time from and including 6 but less than 9 minutes
TTD 4 (9–12 min)
The number of Customers with a transaction time from and including 9 but less than 12 minutes.
TTD 5 (12–15 min)
The number of Customers with a transaction time from and including 12 but less than 15 minutes.
TTD 6 (15- min)
The number of Customers with a transaction time from and including 15 minutes.
Booking 1 (0–2 days)
The number of Customers that booked their Appointments from 0 (the same day) to 2 days in advance.
Booking 2 (3–4 days)
The number of Customers that booked their Appointments 3 to 4 days in advance.
Booking 3 (5–6 days)
The number of Customers that booked their Appointments 5 to 6 days in advance.
Booking 4 (7–8 days)
The number of Customers that booked their Appointments 7 to 8 days in advance.
Booking 5 (9–10 days)
The number of Customers that booked their Appointments 9 to 10 days in advance.
Booking 6 (11- days)
The number of Customers that booked their Appointments 11 days or more in advance.