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
Maurice,
Do you have T-Stats? You could use the Seat cube to get this information.
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.
You may need to create one scenario and save that to list and then bring that list back into T-Stats and use that with your second scenario. For Orders I would use the Tickets Cube. The different Measure and Dimensions you may want to use are:
1. Ticketing Season/Season (Most likely in Filter Slicer)
2. Ticketing Seating/Facility (To select your Venue - Most likely in Filter Slicer)
3. Ticketing Performance Details/Performance Name, or Production Season, or Perf Code Date (Most likely under Categories)
4. Ticket Zone/Zone, Zone Map or Zone Hierarchy (I would pull this first Categories to see what Zones I had in the venue, then move it to Filter/Slicer and select the specific Zone(s) I want)
5. Measures/Ticket Counts and Amounts/Num Tickets pull to Series and select Num Orders
This will get you the number of orders for a specific performance in a specific zone. Then you can save these constituents to a list in List Manager. Mark the list in List Manager to be used in T-Stats. Then in TStats pull your other performances/zones like above but use the new list as a List-Based Filter.
Give me a call if you want to talk this through more. My number is in my profile.
Terry,
Your breakdown was super helpful! I was able to get the information I was looking for!
Thanks,Maurice