Hi folks
I have sales curve comparison widgets set up for each concert strand - so I have eg weekday matinee sales curves since onsale week showing the past 4 seasons sales curves overlaid on each other.
Lovely. So far so good.
But to understand the context of these sales curves further I want to be able to divide each season's sales curve by the number of performances in that concert strand each season. So to continue with the eg above, I want each data point on the 1819 matinee sales curve to be divided by the number of matinee concerts in 1819 (let's say that was 8 concerts), but the 1920 matinee data points to be divided by the number of matinee concerts in 1920 (let's say that was 12 concerts), etc. This way, it will give me an average sales per concert, per strand per season.
I've tried a few formulas that I'm guessing at but to no avail - tbh I'm guessing at these and need someone with a better coding brain than me on this!
(RSUM(Avg([Total Ticket Paid Count])/[# of unique Performance Date and Code]))
I’ve also tried
(RSUM([Total Ticket Paid Count]))/[# of unique Performance Date and Code]
but they don't take account of the differing numbers of concerts in each strand.
Any help from those who do this better than me appreciated!
Best wishes
Melanie
No idea if this will work but if you replace the # of unique performance date and code with (Count (performance id)) does that make a difference?
Hi Melanie,
The divisor is being limited in scope such that in each week since onsale, the ticket count is being divided only by the count of performances that have sales in that week... instead of the total count of performances for the run. You can override the weeks since onsale grouping using the ALL() function. So a divisor more like this (and taking up Madiline's suggestion of Performance ID over Performance Date and Code for this purpose.
( [# unique Performance ID] , ALL( [Order Weeks Since OnSale] ) )
Thanks Chris and Madeline, changing the divisor in this way gives the correct results!
I'm still pretty new to Analytics and realise it can do some cool things, but don't always know how to achieve them! Your help is much appreciated.
Cheers,