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

+1 vote
46 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

  • astauber of JLS - Mar 27, 2024

  • yaakova of Bnos Menachem - Mar 26, 2024

  • GElefant of YGZM - Mar 21, 2024

  • bmiskin of Yeshiva Gedolah Zichron Moshe - Mar 20, 2024

  • cungar of Kollel Chatzos - Mar 18, 2024

  • sstein of Masores - Mar 18, 2024

  • RochelPultman of Prospect Park Yeshiva - Mar 11, 2024

  • rlefkowits of talmud torah ohel yochanan - Mar 11, 2024

  • Barber739 of Bnos Menachem - Mar 10, 2024

  • Chani Schwarz of Yeshiva K'tana of Waterbury - Mar 07, 2024

...