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 Orders and click OK
Add fields to Include records where:
  1. In the left column, expand Sales Order Item node, expand Sales Order Item Ticket node and then select Program Events. From the middle column, drag the Event Record field into Include records where window. In the search field find the pre-registered program event you want to target for this query.
  2. In the left column, expand Sales Order Item Ticket, expand Sales Order Item Ticket Registrant, expand Registrant, and then select Registration Information. From the middle column, drag Question into Include records where window.  In the drop-down field select the question for whose response you want to target.
Add field to Results fields to display:
  1. To output the question response: In the left column, expand Sales Order Item Ticket, expand Sales Order Item Ticket Registrant, expand Registrant, and then select Registration Information. From the middle column, drag Response into Results fields to display window.  With this field selected in this window, click on the pencil icon and edit the column header to display the type of responses (such as T-shirt Size).
  2. To output the count of these responses. From the middle column, drag the same Response into Results fields to display window.  With this field selected in this window, click on the summarize icon and click on the COUNT checkbox.
Save your query:
  1. Click Set save options tab.
  2. Name the query.
  3. We recommend placing the query in a folder so it easy to find.
  4. Save and Close.
Here is an example of what your final query will look like:
User-added image