Hello!
We're trying to gather a list of people who have been consistent donors to our organization over the past 5 years (Fiscal Year 18-22). We're not looking at how much they've given (it could be $10/year), what funds they've given to, or how many unique times they've given each year. It's about the consistency of giving every single year. Ultimately, our goal is to recognize these committed donors in the annual report, on a donor board in the Museum, etc. Once we get the 5 year report to work in Analytics, we want to pull it for 10, 20, etc. years too.
This is currently what I tried to set up for my colleague and not sure what's the best way to go about it. Any help is appreciated!
Thanks,
Amanda
Good idea! I just made this in my sandbox dash based on your idea. I'm filtering to any individuals and households who has a current membership and then counting the number of unique fiscal years of their contributions. I also have a filter so it's only grabbing 5+ year donors.
Thank you! I think this is exactly what I was looking for.
Ah yes, Nathaniel is right, this isn't going to give you consecutive years necessarily. Just the total number of years that they donated. Although it's also only giving you current members so it's likely that the years that they donated were recent.