Good afternoon,
I'm finally getting to do a deep dive into Analytics after a very long time of only skimming the surface, and I have what I feel like is a very easy thing that is being requested that I am having a hard time figuring out. The request is as such: "A show's tickets and gross vs. selected prior shows same number of days prior to opening (as a graph so I can see a trend" and something similar with subscription package/income trend chart for the past 5 years, so we can see how that is trending as well. Does anyone have a formula for something like this? I'm sure it's out there, and probably staring me right in the face, Preferably a line chart with each show in different colors, but I'll take what I can get!
Thanks,
Matt Lazorwitz
Mystic does almost nothing with packages, but I do have some Analytics thoughts about the first scenario:
That way, you'd be able to see each show's data with a common denominator below them.
The above concept should port well into looking at package sales/revenue, but you'd have to tinker with the formulas a bit. Again, we don't do much with packages, but the formula structure above should give you some momentum a good direction.
Hi Matt,
There's a previous discussion about a similar concept that might help get you started: https://community.tessituranetwork.com/topical_groups/analytics-coffee/f/discussions/30795/sales-pacing-chart---inputting-goals-budgets
I think the example in that discussion is focused on single tickets, but I've done similar charts for packages. I have a couple of rough dashboard templates for these concepts that I'd also be happy to share.
~ Christine
The audio visual version is here