Does anyone have lying around some SQL code that derives the number of consecutive years a constituent has been a donor?
Clarke
That's a tricky one.
1998
1999
2000
2001
2003
2004
2005
2008
2017
2018
What number are you looking for from that sequence?
That is a tricky philosophical question! I say 4, as the longest contiguous stretch, but I don't know if that necessarily is the answer that folks who analyze donor activity will find useful.