Averaging Wait Time if an Inbound Call
I have read through many of the other discussions and have not been able to find a solution to my issue. I am trying to average the wait time of inbound calls, based on a column called Offer Duration, and confirming that the column Queue Name has the word Inbound within the field. Below is the formula I am trying, but it comes back #UNPARSEABLE.
Formating of Offer Duration is 0:03:39
=AVG(COLLECT([Offer Duration]:[Offer Duration], [Queue Name]:[Queue Name], "INBOUND",))
Help Article Resources
Check out the Formula Handbook template!