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
We are still on v11, so when using our standard ticket history table, there is no order_no column. We created a custom table to include the order_no which we are then able to query off of in a list using custom list criteria from the new table.