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

image avatar

ZZ Graeme Carmichael

Community Moderator

Greg

The easiest way would be to use the Updates History dataset.

Metrics

  • DCOUNT(Tickets updated)

Rows

  • Ticket ID
  • Update Date
  • Update ticket assignee
  • Assignee name

Filter

  • Changes Field Name = assinee_id
  • Ticket solved = Your date range
  • Ticket status = Closed

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


This was exactly what I needed. Thank you very much. 

0


Hi ZZ Graeme Carmichael

how about created a new attribute?

can we?

0


image avatar

Mike DR

Zendesk Customer Care

Hi Saasten!
 
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


Please sign in to leave a comment.

Didn't find what you're looking for?

New post