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. 
  1. Go to Analysis > Information Library > Queries.
  2. Add an ad-hoc query.  Select type of Sales Order. Click OK.
  3. In the left pane, expand Sales Order Item, Sales Order Item Ticket.  Select Program.
  4. In the middle pane, select Name and drag this into Include Records Where.  Apply Criteria of equal to your program name.
  5. In the left pane, select Sales Order and drag Refund status text into Include Records Where.  Apply Criteria of equal to Not refunded.
  6. In the left pane, expand Sales Order Item, Sales Order Item Ticket.  Select Program Event.
  7. In the middle pane, select start date and drag this into results fields to display.
  8. In the left pane, select Sales Order Item.  In the middle pane, select Quantity and drag this into results fields to display.
  9. In the Results Fields to Display, delete Lookup ID.  
  10. Then, select Quantity.  Click on the summarize button and select SUM.
  11. Save the query on the Set Save Options tab.



Environment

 3.12

Was this article helpful?