Register today for Oracle CloudWorld. October 17th - 20th, Las Vegas

Register now

Hillel Cooperman, Senior VP of User Experience Design, has a message for you on Oracle CloudWorld

Watch now
Incident report - assigned to a second group — Cloud Customer Connect
You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

Incident report - assigned to a second group

Accepted answer
17
Views
1
Comments
edited Sep 23, 2020 5:05AM in Reporting & Analytics for B2C Service 1 comment

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. 

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!