I can't believe I've not been able to work this out for myself- but I'd like to break down orders by the number of tickets they contain. (i.e. for any production the number of orders containing 1 ticket, 2 tickets, 3 tickets etc.)
I'd thought the formula might be (count([Order ID]) , [Ticket Count] ) with ticket count filtered to =1 or =2 or whatever, but that's throwing up some strange numbers that clearly aren't right.
Thanks!
Hi Lawrence,
Check out this post and see if it get's you going.
(34) How To: Count of Orders with only 1 ticket, only 2, and 3+ - Discussions - Tessitura Analytics for Marketing and Ticketing Operations (TAMATO) - Tessitura Network
Thanks again, Chris. Works a charm.
After some further testing I've actually discovered that the formula doesn't seem to be functioning as it should in our environment.
SUM ( [Order ID] , IF ( [Total Ticket Count] = 2, 1, NULL) )
My understanding is this should count orders containing only 2 tickets, but when I check what's included I've found several instances of orders containing 3 tickets counted in here.
Can you spot what I might be doing wrong?
Thanks.
Hi Lawrence...
Auditing this formula can be tricky... the formula will break out of any Order ID grouping you might apply, so to get on the same page about that, here's an auditing example...
OrderCount.dash