How to query on how many people attended each program event

Sometimes you might need a quick summary to see how many people attended each of your program events for a particular program.  You can build a query to get this information in a quick snapshot. 
Start your query:
  1. Navigate to Analysis, then click on Information library
  2. Click Add an ad-hoc query
  3. Select source view of Sales Order and click OK
Add fields to Include records where:
  1. From the left column, expand Sales Order Item, expand Sales Order Item Ticket, and select Program. From the middle column, drag Name into Include Records Where. Set Equal to your program name.
  2. From the left column, select Sales Order. From the middle column, drag Refund status text into Include records where.  Set Equal to Not Refunded.
    • Note: Manually type Not Refunded. This is spelling and case sensitive.
Add fields to Results fields to display:
  1. From the left column, expand Sales Order Item, expand Sales Order Item Ticket, then select Program Event. From the middle column, drag Start date Results fields to display.
  2. From the left column, select Sales Order Item. In the middle column, drag Quantity into Results fields to display.
  3. Within Results fields to display, select Quantity. Click on the Summarize button and select SUM.
    • Note: Sales Order Lookup ID defaults within Sales Order queries. If you do not wish to see this in your output, within Results Fields to Display select Lookup ID then Delete using the red X.

Environment

 3.12

Was this article helpful?