• Replies 11 replies
  • Subscribers 413 subscribers
  • Views 52 views
  • Users 0 members are here
Related

Median Ticket Price

Former Member
Former Member $organization

How would I go about pulling the median ticket price for last year?

Exporting it to Excel is fine, but where do I pull the price of every ticket?

 

Thanks

Parents
  • $organization

    Hi Nick,

    Nicole has you covered. You were on the right track with taking some T-Stats results out to Excel.

    Here’s a recipe for this:

    • New report in Seats cube
    • Seat Performance Date / Calendar / Year in Filter/Slicer and filtered to last year (or Seat Order Date if that’s your preference)
    • Measures / Paid Num in Series (or Paid-Reserved Num to be safe, especially if you’re going with Order Date)
    • Seat Order Details / Per Ticket Price in Categories
    • Export to Excel
    • See how many rows there are and grab the middle one

    I hope this helps!

    Cheers,
    Chris

    _______________________
    Chris Wallingford
    Director of Products | JCA
    575 Eighth Ave., 21st Floor | New York, NY 10018
    Phone: 212-981-8417 | Fax: 212-465-2349
    www.jcainc.com
Reply
  • $organization

    Hi Nick,

    Nicole has you covered. You were on the right track with taking some T-Stats results out to Excel.

    Here’s a recipe for this:

    • New report in Seats cube
    • Seat Performance Date / Calendar / Year in Filter/Slicer and filtered to last year (or Seat Order Date if that’s your preference)
    • Measures / Paid Num in Series (or Paid-Reserved Num to be safe, especially if you’re going with Order Date)
    • Seat Order Details / Per Ticket Price in Categories
    • Export to Excel
    • See how many rows there are and grab the middle one

    I hope this helps!

    Cheers,
    Chris

    _______________________
    Chris Wallingford
    Director of Products | JCA
    575 Eighth Ave., 21st Floor | New York, NY 10018
    Phone: 212-981-8417 | Fax: 212-465-2349
    www.jcainc.com
Children
No Data