Consecutive Year Giving

Question

Hi. I need to pull a query/export where I can see all constituents who gave 5 years consecutive or more. I tried using the Consecutive Years Report but it only gave me 26 records and that's not correct.

They are not interested in a date range or other gift related information. We only need to see the donors, lifetime giving, the fund description, and the years total.

Can someone please tell me how this can be achieved in either DBV or NXT?

Thank you!

Alex Wong · Answer

how many gift records and how many constituent records you have in your database?

Chantel M Russ · Answer

https://community.blackbaud.com/discussion/comment/309966#Comment_309966

It's for any donor who has given 5 years or more

JoAnn Strommen · Answer

@Bobby Steurer - well said: "To-date, there's STILL no easy workaround to this." It's not an easy pull.

Also, you will have a huge file if you are pulling LTG and funds. Rarely, in my experience does a donor only give to one fund.