Consecutive Years Giving
To help you find constituents who have given gifts in consecutive years, you can now create queries with the Consecutive Years Giving field.
Consecutive Years Giving tracks how many years in a row a constituent gave a gift, starting from their most recent gift and counting backward. For example, if a constituent gave a gift every year for five years, and their last gift was two years ago, their total would be five consecutive years. If a date filter removes any of the consecutive gifts, only the gifts that match the filters will be counted.
From Criteria, select Summary for Gift and Consecutive Years Giving.
For more information see Query.