tracking sales to "extra curricular" events

Lesley Chaney $organization over 3 years ago

Hello all,

I'm trying to create a dashboard to track sales to an "add-on experience" that we are selling through Tessitura. I need to show that patrons have tickets to the concert and the experience on the same date, and that they have the same number of tickets to each, but I'm stuck on how to do that. Any guidance is welcome!

Thanks so much - it was really nice to see/meet some of you next week.

Best,

Lesley

Parents

Chris Wallingford $organization over 3 years ago

Does something like this work, Lesley?

For each constituent, and then for each of their performance dates, if the total tickets to the concert equals the total tickets to the experience, then count that constituent.

SUM ( [Constituent ID] , 
   SUM ( [Days in Performance Date] ,
      IF ( 
         ( [Total Ticket Count] , [Production Season = Concert] )
         = ( [Total Ticket Count] , [Production Season = Experience] )
      , 1
      , NULL
      )
   )
)

Reply

Chris Wallingford $organization over 3 years ago

Does something like this work, Lesley?

For each constituent, and then for each of their performance dates, if the total tickets to the concert equals the total tickets to the experience, then count that constituent.

SUM ( [Constituent ID] , 
   SUM ( [Days in Performance Date] ,
      IF ( 
         ( [Total Ticket Count] , [Production Season = Concert] )
         = ( [Total Ticket Count] , [Production Season = Experience] )
      , 1
      , NULL
      )
   )
)

Children

No Data