CRM On Demand - Reports and Dashboards (MOSC)

MOSC Banner

Which aggregation rule is effective for generating distinct result given complexity of the expressio

edited Feb 10, 2013 3:07PM in CRM On Demand - Reports and Dashboards (MOSC) 2 commentsAnswered
Hi!

I have this report that requires computation of Support Request --Days to Close.
However, making it complicated in this computation is the consideration of Task duration (End Time minus Start Time) associated in the SR.

Example:

Support Request#1
SR Open Time : December 1, 2012
SR Close Time: December 20, 2012
DURATION: 19 Days

Within the same SR, there are 2 Tasks:
(1)
Task Start Time: December 5,2012
Task Start Time: December 7,2012
DURATION: 2 Days

(1)
Task Start Time: December 10,2012
Task Start Time: December 11,2012
DURATION: 1 Day

Support Request#2
SR Open Time : January 1, 2012
SR Close Time: January 5, 2012
DURATION: 4 Days


Given the above, the report should generate result as follows:

SR#1 Duration = 19 Days - (2 Days + 1 Day)

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center