How to pull report on assignment group change

[ronnie1]

Hi,

I want to pull report on incident table and the report should pull the records which were assigned to "A" group before and reassigned to my "B" group. How to achieve this??

I am able to pull only records which were re-assigned to my group by applying the filter "assignment group change reason" is not empty. Please let me know is there any possibility to pull the records which were assigned to specific group before (like in my scenario "A" group) and later re assigned to my "B" group.

[darius_koohmare]

Hi,

I believe you will need to do some configurations as noted in: Approaches to easy reporting on assignment group history?

As you note, the default behavior is that you only report on the current value (not historical values). So to start tracking historical data, you can:

#1 create an incident_metric for when the assignment group changes to one of the groups you want to track

#2 create a list field that references the assignment group table. Use a business rule on insert that appends the current assignment group into the list field if it is currently not present.

[ronnie1]

Hi Darius,

Thanks for your help Darius. But I have found the solution. Basically we need to run the report on Incident Metric table and then add filters like,

Assignment group -> is -> B (which is my group suppose)

Value -> contains -> A (This will give you the record where an incident was assigned to "A" group before and is currently assigned to my "B" group)

Created -> between -> 01/01/17 and 12/31/2017 (this filter is in case if i want to pull only records between specific duration)