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
Report to only show first/last record of record 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

Report to only show first/last record of record group

Accepted answer
28
Views
14
Comments
edited Apr 28, 2019 9:40AM in Reporting & Analytics for B2C Service 14 comments

Summary

I wish to only show one record (the most recent one) of all records having same values for col1, col2

Content

EDIT:

my example might have been confusing, so I'm adding a simplifies example:


let's say I'm trying to show the first incident each customer opened using these fields:

incidents.ref_no, contacts.email, incidents.created​

example:

10000,   [email protected],   2019-04-29

21304,   [email protected],  2019-04-29

can anyone please share a report definition that does it?

============================================

Hi,

I have a report having the following columns: Email, OrderId, Date.

I want the report to only show the oldest record for the combination of (email, orderId).

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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