• Replies 3 replies
  • Subscribers 962 subscribers
  • Views 83 views
  • Users 0 members are here
Related

Calculating performances with specific remaining capacity

Anh Le
$organization
Hi everyone,
 
I’m still a novice at creating the more complex custom formulas in Analytics, but am hoping that someone here might not mind helping me figure out what type of formula to write to solve what I think is a fairly easy question.
 
If I were trying to build a widget to show – for one entire season – how many performances have fewer than 100 remaining seats with the Seat Status “available,” how would I write that formula? I’ve played around with IF, COUNT, and groupings/aggregations but can’t quite figure it out.
 
Thank you for any helpful tips!
 
 
A close-up of a person smiling Description automatically generated
ANH LE
Director of Marketing & PR
Opera Theatre of Saint Louis
email: ale@opera-stl.org
phone: 314.963.4294 
address: 210 Hazel Ave, St. Louis, MO 63119
facebook icon twitter icon youtube icon linkedin icon instagram icon 
 
Parents
  • $organization

    I haven't worked with Seat Status before, but here are some thoughts. Would you mean 'unsold seats'- basically "which perfs have less than 100 seats available for sale?"? Or are you changing the status of the seats, and want to track that?

    I have a widget that tracks our Virtual Reality pods for their sold (ticket count) vs unsold (seat unsold count) vs availability (seat count) vs % sold (ticket count / seat count). Would that be helpful?

Reply
  • $organization

    I haven't worked with Seat Status before, but here are some thoughts. Would you mean 'unsold seats'- basically "which perfs have less than 100 seats available for sale?"? Or are you changing the status of the seats, and want to track that?

    I have a widget that tracks our Virtual Reality pods for their sold (ticket count) vs unsold (seat unsold count) vs availability (seat count) vs % sold (ticket count / seat count). Would that be helpful?

Children
No Data