We want to look at the following:
The list of constituents who have placed 3 or more orders over the past two seasons, buying at a selected Price Type.
We've run into problems where the list generated doesn't contain the right results, which must mean we're selecting the wrong criteria in list builder. Or perhaps two of the criteria are referencing different tables?
Has anyone else done any analysis by orders rather than performances booked? Any tips / help / solutions greatly appreciated.
thanksAlison AtkinsonLondon Philharmonic Orchestra
Hi Alison,
I would use T-Stats:
In The Tickets cube - Use Ticket - Season as the slicer
Use Ticket Price Types as the Category
Use Number of orders and Number of constituents as the Measures under series and filter the order numbers to be more than three.
You can save this to a list in Tessitura.
Good Luck
Susan