looking for some Help creating a report that shows first call resolution,
not the best at MySQL , would appreciate some help in getting a report that counts the number of first call resolutions , with date/time, agent, queue. Thank You
2 Comments
[ + ] Show comments
-
By "first call resolutions" do you mean tickets that are created as closed tickets? - chucksteel 5 years ago
-
that would definitely be 1 possibility, voicemails and emails are created as opened and then if they are closed the first time they are touched I would like to know.... thanks - 2Leo 5 years ago
-
Unfortunately , I don't see a field in the DataBase to count the amount of interactions a ticket had.... - Channeler 5 years ago
-
You can find the number of changes to a ticket and determine how many there were, so you would want to find those tickets that were created in a closed state (changes = 0) or tickets that were created and then closed on the first change (changes = 1). Correct? - chucksteel 5 years ago
-
Does moving a ticket to a different Queue count as a change ? if not then yes , your description is correct. - 2Leo 5 years ago
-
Yes, moving a ticket from queue A to queue B counts as a change. You can try to build in exceptions like this, but it will make the query more and more complex. - chucksteel 5 years ago
Answers (0)
Please log in to answer
Be the first to answer this question
