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
Aggregate responses per incident — 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

Aggregate responses per incident

Accepted answer
28
Views
1
Comments
edited Oct 10, 2018 1:25AM in Reporting & Analytics for B2C Service 1 comment

Summary

Creating a report to show the aggregate responses per incident (RPI), but getting duplicate values and unable to group results.

Content

Hi all

I'm attempting to create a report which shows the aggregate responses per incident calculation (for an individual agent). I'm able to create it in table view that displays a row for each individual incident - by either grouping results or adding a hidden column to make the count unique - but not a single, aggregated metric.

I believe it's because the report outputs a record for each occurance of an interval type (from the inc_performance table) for each incident.

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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