• Replies 8 replies
  • Subscribers 412 subscribers
  • Views 243 views
  • Users 0 members are here
Related

Extractions

Michael Magnes
$organization

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 

Parents
  • $organization

    I don't know of a way to do it out of the box, but if you comfortable using the query function you could do something like below. It's what we use, but we don't use dates - just campaigns.

    SELECT a.customer_no,a.campaign_no, SUM(cont_amt) AS camp_total, COUNT(ref_no) AS num_camp_conts FROM t_contribution a
    WHERE a.cont_amt > 0 and a.campaign_no = CAMP_NO
    GROUP BY a.customer_no,a.campaign_no

Reply
  • $organization

    I don't know of a way to do it out of the box, but if you comfortable using the query function you could do something like below. It's what we use, but we don't use dates - just campaigns.

    SELECT a.customer_no,a.campaign_no, SUM(cont_amt) AS camp_total, COUNT(ref_no) AS num_camp_conts FROM t_contribution a
    WHERE a.cont_amt > 0 and a.campaign_no = CAMP_NO
    GROUP BY a.customer_no,a.campaign_no

Children
No Data