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
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