With RE:Events, you can plan, organize, and implement every stage of an event. It includes the ability to track participants as well as their involvement with the event itself. This solution provides details on reporting on how often constituents have attended specific events by Event Type.
1. Create a Constituent query. 2. Filter on Participant Has Attended (Event Participations>Participant Has Attended) 3. On the Output tab select the following output fields:
- Participant Has Attended - Name - Event Name - Event Type 4. Run query, confirm the results. 5. Save and close this query. 6. In the Reports section of The Raiser's Edge select Pivot Report and click "New". 7. Click "Include" and then "Selected Records" and then choose your query, including in into the report. 8. Click "Generate". 9. From the PivotTable Field List, drag and drop the "Name" field into the rows section of the report (on the left), 10. From the PivotTable Field List, drag and drop the "Event Type" field In the Columns section. 11. From the PivotTable Field List, drag and drop the "Constituent Count" field into the Drop Totals section of the report (in the center). 12. The report will now display the totals of the constituents' event participation. 13. Send report to excel for final results by clicking the Excel icon.
NOTE: For a more detailed report, specific to only certain event types, modify the query criteria to only filter on your desired event types.