1. Navigate to Analysis>Information library
  2. Click on Add an ad-hoc query
  3. Select source view Sales Orders and click OK
  4. In the left column select Sales Orders. From the middle, drag Transaction date to Include records where. Set equal to your date range, such as this calendar year.
  5. Drag this same field into Results fields to display
  6. In the left column, select Sales Orders. From the middle, drag Refund Status text into Include records where. Set equal to Not Refunded 
  7. In the left column expand Sales Order Item, then expand Sales order Item Ticket, then select Program. From the middle, drag Program Record into Include records where. Set equal to your Daily Admission program.
  8. In the left column select Sales Orders. From the middle, drag Amount into Results fields to display. Within Results fields to display, click on Amount then click the Summarize button. Select SUM.
  9. Click on Lookup ID in Results fields to display and select the red X to delete line item.
Your final query should look similar to below:
Daily Admission Revenue by Day