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.

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.

Calculation engine functionality differences

Call center planning functions are unavailable in Polaris. Learn more about the differences between Anaplan calculation engines.

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 AVGDURATION(Scheduled Number of Agents, SLA, Target Response Time, Arrival Rate) 18.67 21 24 17.34 Amended SLA 90.00% 92.00% 97.00% 90.00% Amended Average Duration AVGDURATION(Scheduled Number of Agents, Amended SLA, Target Response Time, Arrival Rate) 18.26 20.6 23.35 17.04

Disclaimer

We update Anapedia regularly to provide the most up-to-date instructions.