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,
Just coming back to this to say that I ended up doing something similiar to David, but two versions of it. One that is full month over month, and another that breaks this down further by fiscal week so that, we can see more specifically how we are doing in that month to-date.I set this up to have a line graph and then right next to it, the same info and criteria in a pivot table. This way, the precise numbers we need are there, but also visualized in a way that is helpful to see where we are at.
Here are two examples...Full year over year:When using a dashboard filter to a specific month, it automatically becomes this:
That's a great overlay Derek. Would love to see the Dash if you are up for it
Me too....
Heath Wilder and .,,here you go! Hopefully I exported these right haha. One note, I do have these setup use Performance date as the key date factor as we are a Museum and have daily performances, so be aware if that doesn't apply to you. CMHR_WeekvsWeek.dash
This is WAY cool! Thanks for sharing.