Hello,
I am looking to pull a report or list of all of our current members who have been a member for the past 5 (and 10) consecutive years. When attempting to run this as an extraction, the results show all members within the date range..not just the members in all of the dates in the range.
Hi Dan,
You can also accomplish something like this using an extraction with suppression segments. I've done something like this before:
Segment 1: suppress all constituents who were not a member in year 1Segment 2: suppress all constituents who were not a member in year 2Segment 3: suppress all constituents who were not a member in year 3Segment 4: suppress all constituents who were not a member in year 4Segment 5: include all constituents who are a member in year 5.
Segment 5 will contain only the 5-year consecutive members as anybody who missed any of the preceding years would have been suppressed by segments 1-4. If you wanted to use that segment in a larger extraction you could run this one separately and save the 5+ year consecutive members to a list, and then use the list in your larger extraction.
Thank you for this info! It helped a good bit!