How to find patrons who have purchased tickets every year the past X years?

Hi everyone, this sounds so flipping simple but I can't figure it out. I feel like I'm not understanding some basic underlying logic behind lists/analytics/output sets.

I want to analyze the dollar value of patrons based on how many consecutive years they've been purchasing tickets. I figured the first step was to create lists of patrons who have purchased tickets every year the past 5 years, 4 years, 3 years, and so on, then break those lists down in Analytics.

So in my criteria, I select Ticket History Season and figured I could just select all five of the past years, and it would pull anyone who has ticket history in ALL of the selected seasons, but it's not working as I expected. I tried using "In" and "Has" (what's the difference??), I tried using five Ticket History Season criterion for each years, but I'm getting nothing.

What am I missing?? Thanks!

Parents Reply Children