Recent searches
No recent searches
Report on previous assignee of a ticket
Answered
Posted Jul 05, 2022
We recently did an overhaul of our groups, during this update a decent amount of tickets were assigned to the wrong agent. Unfortunately, no one caught this error until after the weekend when most of the tickets went from Solved to Closed.
I'm looking for guidance on building a report that would show tickets that were reassigned, who the original assignee was, and the total count of tickets reassigned.
0
4
4 comments
ZZ Graeme Carmichael
Greg
The easiest way would be to use the Updates History dataset.
Metrics
Rows
Filter
You will then see each ticket, the update date and the assignee changes. You cannot filter by update date as you will not know how far back the original assignee was set.
Making a little more focussed, create a new Standard Calculated Attribute:
IF [Assignee name] != [Update ticket assignee] THEN [TICKET ID] ENDIF
.. and filter this to exclude NULL.
That checks if the last assignee name is different form a previous assignee.
1
Greg Choisser
This was exactly what I needed. Thank you very much.
0
ZdS
Hi ZZ Graeme Carmichael
how about created a new attribute?
can we?
0
Mike DR
It's possible to create a new attribute, like how the first comment did:
IF [Assignee name] != [Update ticket assignee] THEN [TICKET ID] ENDIF
0