Afternoon all,
Hoping the hive mind can help me out once again... Earlier this year we held our 2019 Jazz Festival, and I'm trying to use Analytics to find out some data on how at what rates different price bands (i.e. zones in Tess) sold. For some context, we're a festival and most of our venues are tents, and this year for our largest Jazz Festival venue, the Big Top, we decided to use a tent with a much higher capacity. This altered the structure of the price zones somewhat from previous years.
Basically, in an ideal world I would like to be able to see how many tickets we had sold for each price band for this venue, the value of these and what % capacity we were at for each, at the end of the festival but also as a snapshot around halfway through our sales period. The first part is fairly straightforward; where I come unstuck is the snapshot part. When I try and filter my widget by a certain range of sales dates (I'm using Order Date for this) the figures I get back are all over the shot.
I'm adding together tickets sold, unsold, reserved and comps to produce my capacity figure as I don't want to include holds, but this doesn't seem to calculate properly if I'm looking at a previous date range. Also, I've compared the tickets sold figure to a different report and that seems to be wrong too.
Any suggestions would be much appreciated!
Thanks,
Emily
Trying to filter out hold codes seems to be problematic right now for GA facilities (which I'm guessing is what you'd use for tents at a festival, though admittedly I don't know much about festival business models). There's another active thread discussing the issue. Further, doing percentages over time hasn't been solved yet either. I was asking at Conference, but couldn't get a solve, and I've seen it brought up in a similar thread.It seems like you've got a workaround for the first problem, but I can point you in the right direction on the second.
This is from Chris Wallingford by way of Conference, but it works out for me.
There's an undocumented function RPSUM with parameters RPSUM (<Variable>, <TIMEFRAME>). Now, I'm using it keyed to months, and want a rolling renewal rate of 12 months back, so mine is RPSUM( [Total Renewed Membership Count] , 12 ) / RPSUM ( [Total Membership Count] , 12 ). I'm not sure what your desired time increment is, if it's daily/weekly/monthly. But RPSUM is probably what you want to play with. You may be able to get it to onto a different time increment by using a different increment on your X-Axis (I'm using Months).