Start your query: 
  1. Go to Analysis > Information Library 
  2. Click Add an ad-hoc query 
  3. Select the source view of Constituents
Add criteria to Include Records Where: 
  1. First, you will need to add criteria to your query to find everyone who made a donation during our date range. In the left column, highlight Revenue. In the middle column, drag Date into Include Records Where and set this to be your date range. 
  2. Next, you will want to tell Altru what you consider a donor. To find everyone who made a donation, expand Revenue in the left column (where we highlighted in Step 1). Under Revenue, highlight Application Details. In the middle column, drag Application to Include Records where. Set this to be equal to Donation. If you'd like to get more specific with revenue, see our solution What query filters should I use to find contributed revenue? for field suggestions. 
Add fields to Results Fields to Display: 
  1. Next if you'd like to see a number only, you can choose to COUNT the constituent Name field that is already in the output of the query. Click the Sigma sign above Results fields to display and check the box for COUNT: 
    User-added image 
    • Note: You can also add any additional details you'd like to see about these donors, but be careful to not add one-to-many fields that would cause your query results to duplicate as this will inflate your count. For more information about duplicating in query, see our related solution: Duplicate records are appearing in my Altru query results.