Hi folks,
Hoping for some insight again with Analytics! We are a Museum and a super important metric for us is tracking attendance and revenue year-to-date over year-to-date. Our fiscal starts April 1, so essentially, measuring April 1 to today, 2019 vs. April 1 to today, 2018. Is there a way to setup widgets to do this automatically? Essentially, to always look for data from April 1 to today and then match the dates for the previous year?
I know I can filter by month or by day...so hypothetically I could, daily, update the filter to add the next day I need; however, I am hoping there is some type of relative option that might work so that this adjustment always happened automatically when a new day starts.
Simply put, I want a widget that shows me a specific production season's sales from April 1, 2019 to today. And then, if possible, have it also compare that data to April 1, 2018 to the same date as today in 2018,
Hey Derrek,
This sounds like it should be doable. Have you checked out the Membership Sales dashboard in the Memberships folder of Tessitura Dashboards? In there is a Membership Sales Comparison widget that compares years. You might be able to use that as a baseline widget to make your own using Seats and Tickets data for attendance and admission sales. You may even be able to add filtering to break up attendance by price type (assuming your membership admissions use a different price type) to see member admission versus non-member.
That's where I would start as a resource. I often still examples from the Tessitura provided dashboards and augment them for my needs.
- Chris
Thanks Chris! That is literally what I was using as an example. Where I keep getting stuck is that it isn't 'to date'. So for example, on June 1...it shows all of June 2018, but then only June 1, 2019 (as the rest of the month hasn't happened yet). So it doesn't help us know where we are trending vs. the year before until we hit the end of the month.
I will definitely keep playing around with it though and see if there is a way to adjust...