Hi All--
I'm a bit stumped on something I feel should be possible... I'm looking to show a % of total capacity sold in the 30 days prior to the first performance of a production season. I'm looking at similar productions all with different capacities, so we're hoping to see a more relative % of the house sold prior to the first perf.
I have a line chart going with Order Days Prior to Opening going on my X-Axis, and my Break by production is working nicely. My formula is a mess, however.
The only clean version I have is to get a running sum of total tickets sold with 'RSUM(SUM([Total Ticket Count]))', but from there I'm stumped on how to pull capacity in and make the formula work. I tried 'SUM([Total Ticket Count]+[Total Seat Unsold Count])' to no avail.
Does anyone have this nailed down? in plain English, I'd like to get a formula going that achieves a running % sold in the 30 days prior to 1st perf (total tickets sold/total capacity), broken by production season.
Many thanks for any help!
Michael Buffer | Park Avenue Armory
Hi Michael,
To get that total seat count for all events in the widget, but from within each day prior to opening, we need a formula that will over-ride the days prior to opening grouping. All unsold seats have a 0 for days from opening. And the sold seats are scattered across all those other days prior to opening in the widget. The ALL() function will give you access to break out of the grouping and retrieve the total across the whole widget.
( [Total Seat Count] , ALL ( [Order Days Prior to Opening] ) )
Thus to get a running % capacity sold...
RSUM ( [Total Ticket Count] ) / ( [Total Seat Count] , ALL ( [Order Days Prior to Opening] ) )
Chris, that worked brilliantly! I did not know the ALL function... I'll have to explore it further.
Glad to hear it, Michael,
There's a little more about ALL() on this help page:
Tessitura v15 Help System - Filtered Values (tessituranetwork.com)
Cheers,Chris