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

  • eerps of Cheder Chabad of Monsey - May 20, 2019

  • Tmendlowitz of Cheder Chabad of Monsey - May 16, 2019

  • Weisblum of Bnos Jerusalem Dchasidei Belz - May 13, 2019

  • gitta of Yaldeinu school - May 01, 2019

  • Briendy of Yeshivat Ohel Torah - May 01, 2019

  • total1542 of Business Halacha - Apr 29, 2019

  • moishey of hatzalah of KJ - Apr 09, 2019

  • sbender of Yeshiva Bais Binyomin - Mar 26, 2019

  • blschwartz of Yeshiva Bais Binyomin - Mar 18, 2019

...