Custom column sample formulas

Note: The formulas are copy-paste friendly when the selected language is English.

Use case	Sample formula
Transfer rate based on handle for customers that prefer a different denominator.	`(Transferred / Handle) * 100`
Percentage answered with outcome-based denominator instead of being based off offered count.	`(Answer / ( Answer + Abandon + Flow-Out ) ) * 100`
Average hold based on handle count.	`Total Hold / Handle`
Create custom calculations for all three options listed in Configure contact center analytics options so that they can be applied to specific scenarios.	All three options enabled: `((Answer - Over SLA) / (Answer + Abandon + Flow-Out)) * 100` Include flowouts enabled: `((Answer - Over SLA) / (Answer + Flow-Out)) * 100` Include abandons enabled (exclude short abandons): `((Answer - Over SLA) / (Answer + Abandon - No Short)) * 100` Include flowouts and abandons enabled (exclude short abandons): `((Answer - Over SLA) / (Answer + Abandon - No Short + Flow-Out)) * 100`
Offer count that excludes conversations that disconnected quickly.	`Offered - Short Abandon`
Average ACW using handle as denominator.	`Total ACW / Handle`
Average handle that excluded hold time.	`(Total Handle - Total Hold) / Handle`
Occupancy that includes Communicating.	`((Total Interacting + Total Communicating) / (Total Interacting, Idle, and Communicating)) * 100`
Percentage of alerted conversations that were answered.	`(Answer / Alerted) * 100`

Next Suggested Article: