The LYBUNT and SYBUNT queries show constituents who have given either donations or memberships last year or some year, but not this year. If you'd only like to consider donations in your results, you can use one of the following solutions to narrow your results:

Solution 1: Create a query to use as a selection in your Smart Query
  1. Go to Analysis > Information Library
  2. Click Add a new ad-hoc query
  3. Select the source view of Constituents. 
  4. In the left column, expand the Revenue Node. From the middle column drag Date to Include Records where and set this equal to last calendar year if pulling LYBUNTS or a set this or before this year. Your field will appear similar to this: Revenue\Date is equal to Last calendar year 
  5. From the left hand column, highlight Application Details under Revenue. From the middle column, drag Application to Include Records Where. Your field will appear like this: Revenue\Application Details\Application is equal to Donation.
  6. Save this query and when saving, mark the box to Create a selection
  7. Open your LYBUNT or SYBUNT Query and Edit Definition. 
  8. Add the query you just created as a selection in the Selected Donors section. 
  9. The LYBUNT or SYBUNT query will now only pull revenue from constituents with donations on their record last year. 
Solution 2: Merge two selections to create a LYBUNT or SYBUNT Query: 
  1. Follow steps 1-6 above to create a selection of constituents that gave Last Year or before this year (any other year). 
  2. Next, create a selection of constituents that gave This Year. You can do this by copying the first query and changing the date filter: 
    1. In Analysis > Information Library, find the query you built in Step 1 (Donors Last Year or Donors Some Year). 
    2. Click the drop down arrows to the left of the query. 
    3. Click the Copy button. This will open a copy of this query. 
    4. In Include Records Where, double click Revenue\Date is equal to... and edit the filter to be: Revenue\Date is equal to This calendar year.
    5. On the Set Save Options tab, give your query a new name. For example: Donors This Year.
  3. Merge both queries using a query merge process: 
    1. In Analysis > Information Library, find the first query you built (Donors Last Year or Donors Some Year)
    2. Click the drop down arrows beside the query and click Merge 
    3. In the query merge screen, search for your second query Donors This Year and add it as Query B. 
    4. Choose "A but not in B" to find LYBUNTS or constituents that appear in the Donors Last Year query, but not in the Donors This Year query. Image of query merge screen
    5. Edit the Selection Name if desired 
    6. On the Select output fields, select what fields you'd like to show in Results Fields to Display. 
    7. On the Set save options tab, name your query and Save.