Chat Average Time to Abandon

Content

I see where historical reporting provides Average wait time to get an answer, but we would like to see Average wait time to abandon.  This would be a date difference from the time that the chat is requested to the time that the request terminates prior to being answered.  I am not sure on all the termination events that should be included, but here it the general idea with a formula that does not work.

avg( date_diff((chats.termination_event IN (5), chats.requested ) )

Does anyone know if this metric can be reported?

Thanks,

Jeff

 

 

 

 

Code Snippet

             avg( date_diff((chats.termination_event IN (5), chats.requested ) )