Incident report - assigned to a second group

Summary

Incident report that shows if an incident was transferred to a different group

Content

Hello,

I've been trying to figure out how to display the following scenario. 

If an agent who is part of group A received a call and then needs to transfer the call to a manager or another agent in a group B (on the same day), I want to see a count of how many such incidents existed for a specific time period. 

I am able to find separate sums of each group for a specific date, but when I try to aggregate twice on the same data, I get an error that sum(sum()) or sum(count()) won't work in this case. I've even tried to have something of a nested if statement to check if group A is true, check for Group B, and if Group B exists on the same ticket sum the raw. I am not sure if nested ifs even work correctly in reports.