Best Way to Report on Attendance per Performance by Hour?

It's budget time at my museum and our CEO is looking very closely at attendance numbers. Currently to get our daily attendance we just pull an "Attendance by Performance Report." This normally works fine, however now our CEO would like to know how many tickets we sell at a specific time per performance (for example he currently wants to know how many tickets General Admission performance tickets we sell on a Sunday between the hours of 10am-12pm). He would like to see about 2 months worth of data, so I need the historical numbers, not getting them as we go. 

What is the best option to get this information? 

Parents
  • 'Order Hour' and 'Performance Date' is your best bet for this:

    This widget is filtered by 'Title' = General Admission and 'Performance Year' = 2023. You also have the widget filters of 'Order Hour' = 10, 11, 12 only, and 'Performance Date > Day of Week Sort' = Sunday only. You can then filter by Performance Date to select only a certain range worth of dates.

Reply
  • 'Order Hour' and 'Performance Date' is your best bet for this:

    This widget is filtered by 'Title' = General Admission and 'Performance Year' = 2023. You also have the widget filters of 'Order Hour' = 10, 11, 12 only, and 'Performance Date > Day of Week Sort' = Sunday only. You can then filter by Performance Date to select only a certain range worth of dates.

Children