How to export Last Event Attended?

Lena Payne
Lena Payne
First Reply Kudos 1 Name Dropper First Anniversary
in Blackbaud Raiser's Edge NXT®: General Discussions

Hi, I am having difficulties exporting a group of constituents with the Last Event attended. Is it possible to do? Thank you in advance.

Comments

  • Dan Snyder
    Dan Snyder Community All-Star
    Tenth Anniversary Kudos 5 PowerUp Challenge - Chat for Blackbaud AI Task 3 bbcon 2025 Attendee Badge

    @Lena Payne
    Not in the way that you can for something like last gift date. I have a workaround but it is a bit convoluted.

    I have a participant export and on the General tab I uncheck the “Have not attended” box under the “Include participants who” area. The fields I export include the constituent id as well as event information, including the date. Attached to that export I have a participant query which for me is simply Constituent ID is not blank so I don't get any guests who are not constituents.

    Then in Power BI (you could do this in Excel or PowerQuery) where I use this data I am able to identify the max date per the constituent ID and only keep those listings where the max date is equal to the event date to get a final last event attended date. Not the most straightforward, but it works for our needs.

  • Lena Payne
    Lena Payne
    First Reply Kudos 1 Name Dropper First Anniversary

    @Dan Snyder thank you so much, I made some changes as I only needed ‘last event attended’ for a certain group of people, and it worked! Thank you for taking the time to share.

  • Chris Zello
    Chris Zello
    Sixth Anniversary Kudos 2 Name Dropper Participant

    If you aren't a PowerBI user, you could use your export file to get what you want from Excel. What Dan has mentioned is very helpful for creating the file.

    With the exported file, I would create a copy of the data onto a new worksheet. Then sort by the SortName and descending StartDate. Then if you go to Data>Remove Duplicates, have it match on ConsID and it will keep only the row with the most recent StartDate. You could use this with a VLOOKUP to pull the info you need into your other file.

Categories