Hi,
I'm trying to create a YOY sales graph, but I'm having trouble because our subscription sales start in March (before our fiscal year that starts in July) and singles continue to be sold through May of the following year. I can get it to show the lines separate from each other (see below), but I can't figure out how to get them to not consider the year so that they'll lay on top of each other. Is that possible? Thanks for your help.
Hi Kanani,
If all the performances within any given campaign fiscal year have, or can be set to have, the same default start sale date, then you could explore using the Order Months Since Onsale field instead of the Order Date itself in months format. Here I have Order Date month in the top widget and Order Months Since Onsale in the bottom.
Here are the help details of the Performance Onsale Date off of which the time Since Onsale is calculated. You can change the onsale of any given performance by editing its Default Sale Start Date in ticketing setup.
Best,Chris
Chris Wallingford Director, Business Intelligence Tessitura Network office: +1 888.643.5778 x553 chris.wallingford@tessituranetwork.com