Hi, all-
Working on a dashboard and I'm trying to compare what percent to goal each campaign is at with a year-over-year comparison. I would like to include the current FY, as well as the last two FYs in the same point in time. I'll be doing the same for our ticketing side, too.
I have figured out this year's percent to goal for each campaign, but am trying to figure out the prior FY(s) portion...
Has anyone done this already, or does anyone have suggestions on how to do this?
Thanks in advance!
Rachel
Hi Rachel,
The last year, same point in time piece, is something I have been struggling with a bit as well...and my understanding is that this isn't something that is 'easily' doable out of the box at this point. It was mentioned though that this is being considered for future releases...as the year-to-date, year-over-year piece is important for attractions like Museums/Zoos.The 'solution' that is working for us is that we have filtered our dashboards by the 'Fiscal Week' (Performance Date) and although we have to add the 'new week' every week, it gives us a pretty good idea of where we are at. This works for us based on what we need, but it is manual.Here is a few other threads that might help...If you created separate widgets for each year, you could probably do something like this to get them to update 'automatically'https://community.tessituranetwork.com/tessitura_software_forums/f/tessitura_shared_reports-9/23110/dashboard-to-run-from-july-1-to-dashboard-run-dateThis post about relative dates in general has some infohttps://community.tessituranetwork.com/tessitura_software_forums/f/tessitura_shared_reports-9/22799/relative-dates-in-analyticsThis thread (referenced in the one above), that talks about some custom formulas that might help...I personally found these a little too complex to maintain, but they might work for you!https://community.tessituranetwork.com/tessitura_software_forums/f/tessitura_shared_reports-9/22047/analytics-weekly-sales-contributions/63423#63423
Derrek,
That's encouraging that it is being considered for future releases (I now see that note in the responses to your post).
Thank you for suggesting the fiscal week filter. I think I may need to follow this approach.
Furtermore, your post from a couple months ago is very helpful. Not sure how I didn't come across it when I was searching the forum before.
Thanks for your help!