Orchestra Business Intelligence User Console Basics : Business Intelligence Calculations : Transactions
  

Transactions

The following sections are available for the creation of Transaction reports, together with the General sections: Branch, Date, Staff, and Time.
Calling Method
Name
Description
Called by
Defined called type (defined in dim_visit_call_type table).
Context Marketing
Name
Description
Vertical Message Name
The name of the Vertical Message.
Customer
Name
Description
Gender
The gender of the Customer. One of ”F” (Female) , ”M” (Male) or ”U” (Not set)
VIP Level
The VIP level of the Visit, e.g. “1” or “Gold”
Language
The language that was used to serve the Customer, e.g. ”English”.
Day filter
Name
Description
Day
Relative date selection.
Service
Name
Description
Queue Type
The name of the Queue type.
Queue Name
The Queue name.
Service Name
The Service name.
Visit
Name
Description
Entry Point
The configured name of the entry point where the Visit transaction was initiated.
Service Outcome
The configured name of the Service outcome for the Visit transaction.
Service Point Name
The configured name of the Service point where the Visit transaction was served.
Work Profile
The Work Profile name.
Visit Outcome
Name
Description
Visit outcome
Visit outcome, as defined in table dim_visit_outcome.
Measures/Metrics
Name
Description
Transaction Time, Average
The average transaction time
Waiting Time, Average
The average waiting time
Walking Time, Average
The average walking time
Wrapup Time, Average
The average wrap-up time
Transaction Time, within sl
These are the transactions with a transaction time equal to or less than the transaction time service level.
Waiting Time, within sl
These are the transactions with a waiting time equal to or less than the waiting time service level.
Transaction Time, Max
The maximum transaction time
Waiting Time, Max
The maximum waiting time
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.
Transaction Time, Total
The total transaction time
Transactions
The number of transactions
Waiting Time, Total
The total waiting time
Walking Time, Total
The total walking time
Wrapup Time, Total
The total wrap-up time
WTD 1(0–3 min)
The number of Customers with a waiting time from and including 0 but less than 3 minutes
WTD 2 (3–6 min)
The number of Customers with a waiting time from and including 3 but less than 6 minutes
WTD 3 (6–9 min)
The number of Customers with a waiting time from and including 6 but less than 9 minutes
WTD 4 (9–12 min)
The number of Customers with a waiting time from and including 9 but less than 12 minutes
WTD 5 (12–15 min)
The number of Customers with a waiting time from and including 12 but less than 15 minutes
WTD 6 (15-min)
The number of Customers with a waiting time from and including 15 minutes
Identified customers
The total number of Visits with a customer id. Not all Visits may have a customer id, so this is the number of Visits that have a customer id, no matter if the same id appears multiple times.
Unique identified customers
The total number of unique customer id. This is the total number of unique Customers, so multiple occurrences of the same customer_id are counted only once.
Number of single visits
This is the number of Visits where the customer id only appears once. The same Customer has not performed any more Visits.
Max customer visits
The maximum number of Visits for a customer id