How to report number of registrants by registration option

For special events, it is always good to have a count of how many registrants are attending.  Sometimes, you want a count of how many registrants are attending depending on their registration option.  For example, you want to see how many VIPs are attending or sponsors are attending.
Start your query: 
  1. Go to Analysis > Information Library.  
  2. Click Add an ad-hoc query.
  3. Select type and source view of Registrants and click Ok.
Add fields to Include Records Where:
  1. To filter on your event, in the left column, highlight Event. From the middle column, select Event Record and drag the field into Include Records Where. Search for your event and click OK. Your filter should read: Event\Event Record is equal to <your event>.
  2. To only include registrants who are planning to attend, in the left column, click on Registrants at the top. In the middle column, select Will not Attend and move this to the top Include Records Where box.  Set the criteria to equal to No. Your filed should read: Will not attend is equal to No.
  3. We will also want to eliminate guests that are not attending. In the middle, select Attended/No-show and move this to the top Include Records Where box.  Set the criteria to be not equal to No-show or is blank. Your field should read: Attended/No-show is not equal to No-show or is blank.
 Add fields to Results Fields to Display: 
  1. For Registration Name, Name is included in the Results Fields to Display of a Registrants Query by Default. 
  2. To see which option they are registered for, use the field: Mapped Registrations\Registration Option.
  3. To get a complete count of each registration option, use the COUNT function, to Count Name. Highlight Name in Results fields to display and click the Sigma sign and select Count. 

Environment

 3.15

Was this article helpful?