Hello!
I am trying to pull a list of constituents that have a ticket history of only one performance.Based on similar types of list pulls I've found posts on here, I am using "Ticket Number of Unique Perfs = 1", I also tried "Ticket Number of Unique Perfs <=1". However, in both instances the returned constituent records all have ticket histories with multiple performances.
Am I using this criteria correctly?
Hi Daniel,
Just curious - is this a criterion that's specific to your site? Our criterion is called "Ticket History Unique Perfs" and is the Tess suplied one and it works just fine.
Could it be related to imported data? We have a lot of imported data where the perf_no value (which I suspect is the basis of your criterion) is -1 which would return people with multiple performances of historical data.
Another question - do you care about people coming to multiple performances or multiple productions? If it's the former, perhaps you could create a new criterion that's based on a combination of perf_name and perf_dt? If it's the latter, you could create a new criterion that is based on just perf_name.
Either would resolve the issue of imported, historical data.
Martin
Boom! This did it. You are absolutely right that it was all import performances marked as -1. Thank you all so much for your help on this!