We are working with a consulting firm who has asked us for some data on our donors. One of their questions is "How many donors have supported you with a gift the past 3 years in a row?" (They also want this information for the past 10 years in a row.) Does anyone know of a report that would give us this information? If not, has anyone figured out a good way to manually calculate this? Thanks in advance!
Since I don’t know SQL, I do it this way:
- Create separate lists for each year
- Create a list of those lists using “HAS”, i.e.
o List HAS 2011 Donors
o List HAS 2012 Donors
o List HAS 2013 Donors
This list will produce a list of only donors who gave all 3 years.
Barbara Pinney
Tulsa Arts Management Consortium
Good thinking Barbara! Thanks so much!