Good Morning,
We're trying to find a way to pull the following information:
In a specific season, we want to know the number of orders which had ticket(s) reserved for a performance in Venue A (may consist of 1-3 different zone maps) and a ticket to a performance in any other venues not Venue A. I'm unable to come up with a report that gives me the specific information. Any assistance would be appreciated.
Thanks,
Maurice
I would do the following in T-Stats:
Go to the “Tickets Cube” and select “New Report”.
Find the Dimension “Ticket Season” and select “Season” drag it up to your “Filter/Slicer”. Once it is there choose only the season you want to analyze.
Now you have a choice:
Either
find the Dimension “Ticket Seating” and select “Seating Hierarchy” drag that to the bottom under “Categories”. If you want only one “Facility” select that facility.
Or
find the Dimension “Ticket Zone” and select “Zone Hierarchy” drag that to the bottom under “Categories”. If you want only one “Zone Map” select that zone map.
find the Dimension “Ticket Seating” and select “Facility” drag that to the bottom under “Categories”. If you want only one “Facility” select that facility and then find the Dimension “Ticket Zone” and select “Zone Hierarchy” drag that to the bottom to the right of “Facility”. If you want only one “Zone Map” select that zone map.
Then find the Measure “Order Counts” and select “Num Orders” and drag that to the right under “Series”.
That should get you the info you are looking for.
Feel free to reach out to me directly if you want my help.
Nicole
Nicole Keating
Assistant Vice President, Business Intelligence
Tel 786.468.2330 Fax 786.468.2005
For Tickets: 305.949.6722 | www.arshtcenter.org
Friend/Fan/Follow for news and inside scoop!
From: Tessitura Ticketing Forum [mailto:forums-ticketing@tessituranetwork.com] On Behalf Of Maurice Nounou Sent: Thursday, June 16, 2016 5:08 PM To: Nicole Keating <nkeating@arshtcenter.org> Subject: Re: [Tessitura Ticketing Forum] Data Extract Importance: High
Terry, I do have T-Stats and have tried a number of times to get this information with no luck. Unfortunately I'm not necessarily that experienced with T-Stats so I'm sure there are recipes and such I'm unfamiliar with.
From: Terry Stevens <bounce-terrystevens8563@tessituranetwork.com> Sent: 6/14/2016 4:46:43 PM
Maurice,
Do you have T-Stats? You could use the Seat cube to get this information.
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!
Hey Nicole,
All I'm looking for is a way to get a the total number of orders in any given season which have performances in 2 or more different venues.
The issue I'm running into is finding a total number of orders that have a ticket to a performance in Venue A and a ticket for a performance in Venue B. I may not be doing it correctly, but what you're suggesting only seems to show a number of orders for each Facility specifically. I've tried playing around with a number of combinations for Facility as a filter, Facility Hierarchy as a filter, and neither of them seem to work.
What I seem to need is the ability to use the Facility option twice. In theory, this would allow me to put my Venue A option as the Filter, and then the Venue B as the Categories or Series.