Hi all,
I'm trying to pull together a list that contains all active members who've attended more than 5 times this year. I'd need this to be automated and run daily, otherwise I could draw something up in Analytics manually, and pull that into a list.
I'm able to get a list of Members who've attended 5 or more times across every year, but I can't figure out how to refine the list only to look at this year for the attendance.
The only way I can see would be to write out some custom SQL, but I don't have any experience drawing up something that complex.
As a rule of thumb (although not perfect), if you use multiple criteria from one criteria set, in the same list, those criteria should work with each other. So if you use both performance count and season from the same criteria set, you ought to get a result that is five attendances in that season. You can confirm that by looking at the query under manual edit.
To expand, in this example I'm using two values from the List Criteria Set "Ticketing":
And here in the query we can see that both conditions are being applied to the same "FROM" table:
Interesting, I will try this out- thanks! Will let you know of my progress.