• Replies 1 reply
  • Subscribers 414 subscribers
  • Views 138 views
  • Users 0 members are here
Related

Average Ticket Price

David Janeski
$organization

Im certain that Im just blanking on this one, nevertheless...

How can I find average ticket price for a production?

(short of going all math wizard on attendance by performance reports)

Thank you T2 all stars. (no we do not have T-stats, yes we plan to eventually)

Parents
  • $organization

    Maybe there's a report for it - not sure off the top of my head. Here's a quick and dirty sql query that will give it to you. Assuming you're using lt_tkt_hist, and you'll want to check that your fields are named the same as it is a local table.

    select AVG(tck_amt) from lt_tkt_hist where production_no = ####

    replacing #### with your production_no (or prod_season_no depending on how your table is set up.)

Reply
  • $organization

    Maybe there's a report for it - not sure off the top of my head. Here's a quick and dirty sql query that will give it to you. Assuming you're using lt_tkt_hist, and you'll want to check that your fields are named the same as it is a local table.

    select AVG(tck_amt) from lt_tkt_hist where production_no = ####

    replacing #### with your production_no (or prod_season_no depending on how your table is set up.)

Children
No Data