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 RobichauxThe Historic New Orleans Collection
(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)
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
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?
Absolutely! npearson@mysticaquarium.org
Off the top of my head, you might be inadvertently using the DoW from order date rather than performance date? That would explain the unexpected days.
Thank you! That is definitely part of the problem.