Report on all Assignment Group changes

[iDevilsdocry]

Hello,

I have a request to report on all groups that Incident was previously assigned to. I have been able to group incidents based on reassignment count but it only shows current group. I need it to show all group that it has been previously assigned to without having to open each record and looking at activity notes. Is that possible?

In the image below I'm expanding a record with 5 reassignment count but it only shows current group that its assigned to. 

I'm using List Report type

[Uncle Rob · Accepted solution]

You need to use Metric Definitions and Instances.  Luckily Assignment Group already has a metric definition, so all you need to do is report on the metric instance table.  There should already be a database view that joins this with incidents.

There will be one record for each time an Incident was re-assigned and how long that group was assigned to the ticket.