Median Ticket Price

Cool have to give this a try.

--Tom


On Mon, Feb 8, 2016 at 7:27 PM, Chris Wallingford wrote:

Hi Nick,

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

[http://www.tessituranetwork.com/Community/resized-image.ashx/__size/550x0/__key/CommunityServer.Components.UserFiles/00.00.00.26.60/PerTicketPrice.png]

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
From: Nick Torres
Sent: 2/8/2016 2:48:59 PM

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



This message was sent automatically to you by www.tessituranetwork.com because you subscribed to the Tessitura Ticketing Forum. You may reply to this message to post to the Ticketing forum or visit the site to search, read and post to the forums. In the interest of keeping the forum posts from becoming cluttered, we encourage you to delete previous message text from your reply before sending. Thank you!

Cool have to give this a try.

--Tom


On Mon, Feb 8, 2016 at 7:27 PM, Chris Wallingford wrote:

Hi Nick,

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

[http://www.tessituranetwork.com/Community/resized-image.ashx/__size/550x0/__key/CommunityServer.Components.UserFiles/00.00.00.26.60/PerTicketPrice.png]

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
From: Nick Torres
Sent: 2/8/2016 2:48:59 PM

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



This message was sent automatically to you by www.tessituranetwork.com because you subscribed to the Tessitura Ticketing Forum. You may reply to this message to post to the Ticketing forum or visit the site to search, read and post to the forums. In the interest of keeping the forum posts from becoming cluttered, we encourage you to delete previous message text from your reply before sending. Thank you!