Report of All "group reassignment" bins used?

[RC2]

I need a report that shows a list of all Assignment Groups that a ticket was reassigned to. You know how there is the field "Group Reassignment count", if the count is "4" then I need to know the list (and order/time stamps) with the actual group names. I'm trying to find out which teams first actioned a ticket or what the "lifecycle" of the tickets were, in order. Example: 1) User Helpdesk team, 2) Support team one, 3) Support team two, 4) back to Support team one who closes the ticket. Right now I feel like I have to scan the Notes tab manually to see what happened in the ticket, which is inefficient. 

[AndersBGS]

Hi @RC2 ,

Have you looked into metrics/ metric devotions? According to your requirement, I would think that this will be the best solution. Furthermore for your information, there is already a incident metric by assignment group OTTB.

If my answer has helped with your question , please mark my answer as accepted solution and give a thumb up.

Best regards

Anders

[RC2]

I've tried the OTTB incident _metric table but I'm not sure the exact setup I need to get the data I want. If I search for a specific value (i.e. a specific assignment bin), it won't show me the other assignment bins that a ticket was in. Due to volume, I need a way to only see the tickets that were, at some point in their lifetime, assigned to a specific group that we own. That's where I'm stuck. If I do a general search for like "all tickets opened after XX date" with the Definition = Assigned to Duration, then I can see all bins. But that doesn't allow me to filter out tickets that weren't ours.