My organization want to know the names of families who have come to multiple of our Community Days. I am trying to pull it in List Manager but I seem to be getting stuck. I even tested it on Performances where I know we have had the same person go to both, but when I click "Go to Result" it says "no results found."
I think my issue is when I add the two performances from the "Ticketing" filter, it has OR in the middle if they are on the same line. To get around that (because I need AND), I just create two lines of data with each performance on one line. Clearly that isn't working because I am getting no results.
Does anyone know how to change the OR to AND in List Manager so I can actually get the data I need? My Primary Criteria in my input looks like this (testing the yoga class I know I'm on the list for every week):
Output is simply First/Last name and Email address.
Chelsea Marti,
Been a while since I did this in List Manager myself, but I am pretty sure you want both of those to be "Has" if you are looking for someone who went to both. Using "IN" will not work because that is trying to look for a row of ticket history that belongs to both performances, which is essentially impossible. By using "Has", you are saying "I want patrons who have X somewhere on their record who also have Y somewhere on their record, too". The documentation on In/Not In/Has/Does Not Have is a little much to get through but worth understanding.
Best of luck!
John A. Moskal II
Now it worked! Thanks John!