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).
Hi Emily,
I have a few thoughts for you on your goals with this reporting effort.
Reporting on capacity generally will include holds. Seat Unsold Count does not exclude holds natively. Reporting on Unsold inventory, excluding holds, is probably easiest using a Filtered Value approach. Using the [Seat Count] value, filter it on Seat Hold Code = (none). It'll look like this:
Reporting on available capacity at a moment in time, based on Order Date, can easily remove unsold seats from your report. Note here, Order Date at the top, an all the unsold seats are under 1/1/1900 and no unsold seats are under 11/2016.
The easiest way to address that is to set your order date filter to be from Earliest Date (which should be 1/1/1900) to the date you're interested in:
With that, I get something like this:
I'm not sure if I've set you on your way, but here's the sample dashboard I used to get to this point at least: Capacity.dash
Best,Chris
Chris Wallingford Director, Business Intelligence Tessitura Network office: +1 888.643.5778 x553 chris.wallingford@tessituranetwork.com