Hi everyone,
I'm building an extraction to pull donor info and I'm trying to find people who have given at least twice in a specific time period for a segment. Is there an easy way to do this?
Thanks!
-Michael
Hi Michael, I built something for just this reason. Hopefully this works for you.Description: Contributions (Number of)Type: NumberDetail Tbl: vs_contribution_with_initiatorDeatil Col: count(distinct !.ref_no)Category: contributionUse for list: List Only
It will find people with a specific number of gifts. I would use >= 2 for your example. It should be able to work with all your other gift criteria as long as those are looking at the same table.
Ann, does what system table should this code go into?
It goes in T_Keyword. That's where you can set up a bunch of custom criteria. You may have to get an IT person with permissions to put it in for you. Depending on how your org is set up. Here's the documentation: www.tessituranetwork.com/.../T_KEYWORD.htm
thank you!
Also this worked like a charm. Thank you!
I'm glad it worked!