How do I query for a list of people by comparing how much they gave for different campaigns?

+1 vote
6 views
asked Mar 4, 2015 in How To by Admin
reopened Dec 25, 2018 by yczehn
How do I query for a list of people by comparing how much they gave for different campaigns?

1 Answer

answered Dec 25, 2018 by yczehn
 
Best answer

In queries you can create a query to see if one criteria is greater than the other criteria. Let's say you want to see a list of people that gave less than half of what they gave for a different campaign. You would need to do the following.

 

1. Go in to the query tab. You can follow the same steps by the charges tab or the payments tab depending if you want to compare pledges or payments. You can also mix and match them too, for example to compare a pledge against a payment.

 

2. Select the campaign or any criteria. By the amount dropdown (1) choose campaign1. When finished selecting your criteria click on include. (You can also use the multiplier field (2). Lets say you want to check only whoever gave lass then half you would enter by the multiplier * .5).

 

3. Enter the second criteria that you want to compare with. By the amount dropdown (1) choose campaign2. When finished selecting your criteria click on include.

 

Let's Welcome our New Members

  • blschwartz of Yeshiva Bais Binyomin - Mar 18, 2019

  • Nlink of Yeshiva Bais Binyomin - Mar 18, 2019

  • yachet of Beth Jacob of Boro Park - Mar 13, 2019

  • Shalom of Cong. Noiam Mgodim - Mar 12, 2019

  • mosdosbelz of Mosdos Belz - Mar 11, 2019

  • YosefAltman of Belz LAkewood - Feb 27, 2019

  • mlipschutz of YTT - Feb 19, 2019

  • gz of Bobov 45 - Feb 18, 2019

  • S. Bayer of Bais Malka Monsey - Feb 14, 2019

...