How to filter on the startdate of first event if a person may have multiple events attended?
Report on only the first event
I need to have a report which only displays the first event to which a person has been. So I have the contacts table and a custom Event table. The relationship is one to many, one person can attend multiple events. But I only want to display the StartDate of the first event attended.
I am unsure what I need. I used a group filter to only count one record but that didn't work out. Also the min(Event.StartDate) in a column didn't work out. Do I need a custom script or can I do this with a filtered outerjoin or any other idea?