Reporting on chats transferred from one helpdesk to another
The chat_queue_entry_transfer table holds transfer only between agents. When you transfer a chat queue conversation to another queue, the platform updates the chat_queue_entry record for the current queue to have a status of Closed Escalated. You can therefore see how many transfers occurred for a conversation by searching the chat_queue_entry table where the state is Closed Escalated and then group by the Group field.
How to Report on Transfers
Type "chat_queue_entry.list" in the filter navigator to access the Chat Queue entries.
Sort the entries by queue name.
All the chat entries for that specific queue are listed.
Filter the result by status (in this case, Closed Escalated) and then group by agent.
The count will be displayed next to the list.