The AVGDURATION function calculates the required average duration of calls in order to answer a certain percentage of calls, or service level agreement (SLA).
Syntax
AVGDURATION(Number of servers, SLA, Target response time, Arrival rate)
Arguments
| Argument | Data type | Description |
| Number of servers (required) | Number | The number of servers (for example, call center agents) available to process requests. |
| SLA (required) | Number | The percentage of requests that need to be processed within the Target response time. |
| Target response time (required) | Number | The time after which each request must start to be processed. |
| Arrival rate (required) | Number | The interval between the arrival of each request. |
The AVGDURATION function returns a number. This is the average duration it takes to process requests, using the same time unit as the Target response time and Arrival rate arguments.
Calculation engine functionality differences
Call center planning functions are unavailable in Polaris. Learn more about the differences between Anaplan calculation engines.
Constraints
Time unit for arguments
The Target response time and Arrival rate arguments do not have to use a specific time unit. For example, they can be seconds or minutes. However, each argument must use the same time unit.
Maximum number of servers
The maximum number you can use for the Number of servers argument is five million.
Examples
In this example, the Call Centers list is on columns, and line items on rows. The first four line items contain the data for the AVGDURATION function for each call center:
- The scheduled number of servers to process requests
- The percentage of calls that must be responded to within the target response time, or SLA
- The target response time to begin processing requests within
- The arrival rate, or interval between each request arriving
The fifth line item uses the AVGDURATION function to calculate what the average duration of call is given the number of servers, SLA, target response time, and arrival rate of calls.
The sixth line item enables you to adjust the SLA. The formula in the seventh line item uses the adjusted SLA. This enables you to see how the average duration of calls changes given a different SLA.
Both of the line items that contain SLAs use the Percentage format with two decimal places.
| Call Center 1 | Call Center 2 | Call Center 3 | Call Center 4 | |
| Scheduled Number of Agents | 16 | 22 | 37 | 23 |
| SLA | 85.00% | 87.00% | 92.00% | 85.00% |
| Target Response Time | 15 | 18 | 17 | 12 |
| Arrival Rate | 0.7673 | 0.9621 | 1.428 | 1.213 |
Average Duration
| 18.67 | 21 | 24 | 17.34 |
| Amended SLA | 90.00% | 92.00% | 97.00% | 90.00% |
Amended Average Duration
| 18.26 | 20.6 | 23.35 | 17.04 |
