Hi all,
We use both super packages and regular packages. I am working on recreating a TSTATS report for our subscriptions manager and one of the columns that she relies on is "Package Seats" which gives her the total number of packages we have sold. I found seat count but that sums up all of the seats in the order. I've found if I divide that by the number of shows we have in our regular season it gives me the number I want. The problem is that once we begin to sell our choose your own 3, 4, and 5 play packages this math won't work anymore. So HOW do I pull a column that shows the total number of packages?
Thanks for your help!
Madeline
Hi Madeline,
A package seat count can be derived by creating a value that is a Count Unique of Package Seat Key.
However, if your widget or dashboard is not filtered on only package sales, then this package seat count value may return an additional count of 1 for non-package seats. If you need to eliminate that additional count because you are not filtered to only package related data, apply a filter to the value formula to limit the count to data that is associated with a package... for example, only count unique package seat keys for data where the Package ID is greater than 0.
Or where the Package is not (none) or Zero Package.
Best,Chris
Chris Wallingford Director, Business Intelligence Tessitura Network Office +1 888.643.5778 ext 553 chris.wallingford@tessituranetwork.com Tessitura Learning & Community Conference July 28-August 1, 2019 #TLCC2019
Once again, you're a gem! Thank you.