Hello All!
I work at the MN Historical Society and I've been diving into analytics recently to learn as much as I can. One place I've gotten stuck is when I'm trying to create a dashboard to compare FY19 and FY20 program and admission sales from an order date. Our fiscal year is July 1 - June 30, so I can't use any previous calendar year parameters, it would have to be by me manually changing the date on the order date/calendar. I'd like to have a dashboard that takes sales from July 1, 2018 - December 16, 2018 (this day last year) for example and compare it to our FY20 sales from July 1, 2019 - December 16, 2019 (Today). I can do this with an order date and calendar time frame but it doesn't automatically change the 12/16 date to the date when the dashboard is loaded. Does this make sense? I've uploaded the Dash file on here in case anyone wants to try and help. The dashboard in question is titled "FY19 Admissions & Program From This Day Last Year" but the rest of the board helps give context.
Thanks in advance!
Andy Erickson-Peterson
MNHS Box Office Supervisor
6114.MNHistoryCenter1.dash
Andrew,
I was working on something similar, and was able to get it to work for contributions, thanks to the Tessitura community. I used advanced filtering on the date, specifically this logic:
{ "last": { "count": 1825, "offset": 366 }, "custom": true}
Not sure if this post will help you, but might be worth reviewing:
https://community.tessituranetwork.com/tessitura_software_forums/f/tessitura_shared_reports-9/23255/yoy-analytics/68027#68027
Best,
Rachel