Hello:
We are a multi venue general admission destination as the questions hints. I'm trying to find a way in analytics to determine (approximately) the number of unique ticketed individuals an order or collection of orders represent. For example,an individual order could include:
Whilst this could represent tickets for anything from 3 to 7 separate individuals, a reasonably safe assumption is that it is 3 individuals, but one of them has decided not to go tower and has no interest in art. I'm struggling to find a way in analytics to aggregate ticket counts per line to return just the maximum number of tickets on any 1 line in the order (which then I could sum per month, etc) so that I can then use my assumption. As anyone with the same issue solved this?
We do offer packages that are easier to work out, but many tickets sales are still individual tickets. We also don't yet have NSCAN - so stuck trying to solve it as above.
Thanks,
Bob.
Hi Bob,
You have the right idea with that GROUP BY approach. It's especially good if you're using Order ID in your pivot table Categories. You can also group within Performance Date if there are many performances and you don't want to see that detail. More generally, when not grouping by Order ID you can SUM ( [Order ID] , MAX ( [Ticket Count] ) ) so that you are getting the max ticket count within each order rather than within each performance.
Best,Chris
Chris Wallingford Director, Business Intelligence Tessitura Network office: +1 888.643.5778 x553 chris.wallingford@tessituranetwork.com