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
Average calculation using date_diff at summary level vs. report calculations — 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

Average calculation using date_diff at summary level vs. report calculations

Received Response
10
Views
5
Comments
edited Nov 8, 2018 3:33PM in Reporting & Analytics for B2C Service 5 comments

Summary

The average date_diff calculation, used at the summary level, includes cases with a null date value, distorting the totals

Content

I've built two reports (definitions attached).  The Detail report is a report link that is called when a user drills down from the summary level.

In the Summary report, I'm using a formula to determine the average resolution time by Agent, using the date_diff function to calculate the difference between the resolution date/time and the case creation date/time.  In this Summary report, the formula is including cases that have a null resolution date/time.

In the Detailed report link, I'm using the report calculations to display an average at the bottom.  The average resolution time on the detailed report excludes cases with a null resolution date/time.

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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