• Replies 21 replies
  • Subscribers 959 subscribers
  • Views 187 views
  • Users 0 members are here
Related

Aggregate attendance by zone

Anne M Robichaux
$organization

Good morning,

Our guided tours have been suspended since we shut down in March and we don't plan on bringing them back in the near future. But, as we plan for the day that we do, our visitor services manager would like to see a chart showing the average attendance by zone for the last year or two by day of the week. I'm guessing I need to use bucketing to do this, but I was curious if anyone else as put something like this together yet. (I"ll have to go back and rewatch that video!). Here's our setup -- we offer our tours 4 times a day Tues-Sat and 3 times on Sun. I am looking for a bar chart that shows the average number of tickets sold on each day of the week in each of those 4 time slots for a specified time period (not each individual day). 

Any advice would be most appreciated.

Thanks!
Anne Robichaux
The Historic New Orleans Collection

Parents
  • $organization

    (I think I'm onto something, but I gotta talk things through. Here goes!)

    Average Attendance by Zone would be something like [ (total # of tickets , for a specific zone) divided by (total number of zones , for a specific zone) ]. I think that makes sense. So if there were 2 total instances of "zone A", and 100 total tickets sold in "Zone A", the average would be 50.

    I think I've arrived at a workable solution. I'll use our 4D theater (which runs every 30 minutes so far)

    • The first value would be Total Number of Tickets Sold, for 1030 Small Foot Zone:
        •  where you'd filter the 'Zone' one by selecting only the '10:30 Small Foot' zone.
    • The second value would be Number of 10:30 Small Foot Zones:
      •  
    • The third one (the one you were really looking for) would be (Number of ticket sold into 10:30 small foot, divided by Number of 10:30 small foot zones)
        • where you'd just copy in the formulas listed above.

    I tested this out and it seems to work. You could then filter the whole widget by a certain production season(s), and/or certain days of the week. I used a Pivot (they're my favorite), but a bar chart would work as well!

    I don't think you'll be able to get around building a separate bucketing arrangement for each zone, however. In your case, there's only a few zones, so that's not too bad. For our theater, there'd be dozens. The things we do for coherent data!

    Let me know if that helps. This was a fun one Slight smile

  • $organization in reply to Nathanael Pearson

    I think I have it set up the way you suggest, but something is really off. My number of zones per day should be roughly equal and they are way off. Plus, I'm seeing counts on days when we don't even offer tours at this time (we're closed Mondays, and our 10 am time slot isn't available on Sundays). Can I send you my dashboard to take a look at whenever you have a chance? 

  • $organization in reply to Anne M Robichaux

    Absolutely! npearson@mysticaquarium.org

Reply Children