• Replies 1 reply
  • Subscribers 961 subscribers
  • Views 147 views
  • Users 0 members are here
Related

Available seats for a Package

Ashley Voorhees
$organization

Hello...

I'm working on a dashboard that would recreate the Package Base Price and Availability Report. I'm really trying to pull together a formula that will show the available seats by package. 

Here's the formula that I'm using for a performance

   ( [Total Seat Unsold Count]) - (  [Total Seat Count],  [Resale Status],  [Seat Hold Code])

When I apply this to a package it comes out as 0. I've tried changing the formula to look at Package Seat Key but not having any luck. 

Any suggestions? 

Thanks,

Ashley

Parents
  • $organization

    Hi Ashley,
    In Tessitura Anlaytics the Seats and Tickets cube only includes all Performance Seats and any Order Tickets whether associated with one of those performance seats or unseated. If a ticket is sold to a performance as a part of a package, then the package information related to that ticket is available in Analytics for reporting. Unsold performance seats are only tied to packages through performance groups in Tessitura. A performance event and thereby its seats can be in many package groups, which is confusing in an analytical context.

    If however, you're okay with a widget per Package/Product, then you could filter a Pivot Table widget to the Performances in single package group for that package. Use Zone on Rows. If you only have a single Price Layer on the base price for those seats, you might be able to simply put Seat Home Base Value on Rows as well. If you do have layers you can either put it on Rows and then filter the widget on Price Layer Category set to only include Ticket Price, or you can create a value to take the MIN( [Seat Key] , SUM( [Seat Home Base Value] ) ) to get the minimum total base value (across all performances) for any seat within each zone. For the Available Seats, we'd similarly take the MIN ( [Performance ID] , SUM( [Seat Unsold Count] ) ) to get the minimum availabe seats from any of the performances for that zone.

    This format of aggregating a value by a dimensional field prior to aggregating for a final result, is not often necessary, but is referenced in:
    * Contribution Income pre-built dashboard  (expand Dashboard Widgets > Campaign Progress and look at the % of Goal description.
    * Take Your Tessitura Analytics Skills to the Next Level  (the Goal Amounts starting at 2:50)

    Best,
    Chris

    Chris Wallingford
    Product Owner
    Tessitura Network
    Office +1 888.643.5778 ext 553
    chris.wallingford@tessituranetwork.com
Reply
  • $organization

    Hi Ashley,
    In Tessitura Anlaytics the Seats and Tickets cube only includes all Performance Seats and any Order Tickets whether associated with one of those performance seats or unseated. If a ticket is sold to a performance as a part of a package, then the package information related to that ticket is available in Analytics for reporting. Unsold performance seats are only tied to packages through performance groups in Tessitura. A performance event and thereby its seats can be in many package groups, which is confusing in an analytical context.

    If however, you're okay with a widget per Package/Product, then you could filter a Pivot Table widget to the Performances in single package group for that package. Use Zone on Rows. If you only have a single Price Layer on the base price for those seats, you might be able to simply put Seat Home Base Value on Rows as well. If you do have layers you can either put it on Rows and then filter the widget on Price Layer Category set to only include Ticket Price, or you can create a value to take the MIN( [Seat Key] , SUM( [Seat Home Base Value] ) ) to get the minimum total base value (across all performances) for any seat within each zone. For the Available Seats, we'd similarly take the MIN ( [Performance ID] , SUM( [Seat Unsold Count] ) ) to get the minimum availabe seats from any of the performances for that zone.

    This format of aggregating a value by a dimensional field prior to aggregating for a final result, is not often necessary, but is referenced in:
    * Contribution Income pre-built dashboard  (expand Dashboard Widgets > Campaign Progress and look at the % of Goal description.
    * Take Your Tessitura Analytics Skills to the Next Level  (the Goal Amounts starting at 2:50)

    Best,
    Chris

    Chris Wallingford
    Product Owner
    Tessitura Network
    Office +1 888.643.5778 ext 553
    chris.wallingford@tessituranetwork.com
Children
No Data