Hello smart Tessiturian minds,
I am stumped.
I am building an extraction and one of the segments I need to find single ticket buyers who have attended for the past 5 consecutive years and have only purchased either 1-2 performances for each season.
I have for my criteria:
Ticket Seasons in (Fy 08,09,10,11,12)
No of performances<=2
Ticket S or P= S
Ticket Performance Type=Symphony Performances
I have run this a bunch of different ways, and am not getting results anywhere near where they should be. I have no clue where I am going wrong. Is the Number of performances a total for all seasons combined or is it looking for people who have 1-2 performances per season? Any advice is appreciated!
P.S. This is still V10.
Thanks!
Is it pulling a smaller or larger number of people than you would expect? My hunch is that it will pull only people who have attended less than 2 over all of those seasons combined not per season. To get at a per season I think you need to give each ticket season a separate criteria.