Hi All! Let me preface this by saying I'm a Devo person, so I'm not as versed in the ticketing side of things. That said, I'm trying to pull together a list which includes the number Subscriber Seats for our 18-19 Season, but we only want the number of seats purchased with their subscription, not the number of tickets total that they received as part of their subscription. For example, Jane Doe purchased four seats in a five show subscription in 18-19, so she received 20 tickets total (four seats to each of the five shows) but we only want to count the base four seats, not the 20 total. Does that make sense?
I've built out a pivot table in Analytics using the Seats and Tickets cube and have been testing out different ways of pulling this information, including Package Size, Seat Count, Ticket Count, and Ticket Paid/Reserved Count. In each case when I spot check by going into the constituent's record the number appearing doesn't match the number of seats listed in that package. I've tried setting the value to Sum, Count All, Count All Unique, Min, and Max just to see what happens and I haven't seem to have found the magic formula. Anyone know what I might be doing incorrectly?
Thanks!
Colleen
Hi Colleen,
As I read this it seemed an easy one - use 'Package Seats' (count). This is something I use in T-Stats all the time. I just had a look in Analytics and i could not find 'Package Seats'. I'm interested to see if there is a work around or if Package Seats will be added in an upcoming update. Sorry that I could not be more helpful Colleen.
regards,
Michael
I use this: ([# of unique Package Seat Key], [Package ID]) with the package ID filtered to all items greater than 0.
Hi Madeline - I ran into this and used count([Package Seat Key]) to solve.
No worries! I appreciate your input (and I'll keep an eye out for Package Seats in newer versions).
Hi Madeline,
I actually just used Package Seat Key with Count All and that seemed to have done the trick! Thank you!