Report to only show first/last record of record group
SummaryI wish to only show one record (the most recent one) of all records having same values for col1, col2
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
10000, [email protected], 2019-04-29
21304, [email protected], 2019-04-29
can anyone please share a report definition that does it?
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).