Use the Consecutive Giving Years Smart Field in Altru:  

Note: 
 Consecutive giving years include the current year. If you do not want to exclude anyone who has not given this year, Adjust the date filter to end at the end of the last year.
  1. Click Administration > Smart Fields
Note: If you do not see smart fields on the Administration tab, please contact your system role administrator to have the Smart Fields system role assigned to your user
  1. Click the arrow beside the Consecutive Giving Years smart field
  2. Click Process Smart Field. You may also want to consider adding a Job Schedule so that your smart field is always up to date. 
Note: Smart fields do not process or update automatically.  Go to the Job Schedules tab, and add a job schedule to process the smart field on a regular basis.
 
  1. Review the information on a constituent record or in the default query named, Constituents with Consecutive Giving Years, to make sure the data is correct. 
    1. Click Analysis > Click Information Library
    2. Search for the query named Constituents with Consecutive Giving Years
    3. Click the arrow beside the query, and click Edit
    4. Click Preview Results
Note: If the Consecutive Giving Years smart field is not showing what you expect, it may need to be set back to the default settings. Alternatively, the Constituents with Consecutive Giving Years query may need to be set back to the default settings


If needed, you can edit the default Smart Field:
  1. Edit the Consecutive Giving Years Smart field > Click the Parameters tab
  2. Mark the revenue types and applications/transaction types that should be included
  3. Enter a date range, if needed, or leave the dates blank to look at all years
    • Note: By default consecutive giving years will look to the present date. If Constituents have not given in this calendar year and the end date is in this calendar year they will not pull. This is so that if someone gave in 2005 and 2006, in 2006 they would have given in 2 consecutive years. However, if they do not give again until 2011 and give every following year then the 2005 and 2006 information would not be counted. 
  4. (Optional) Under Application Selection, you can narrow your smart field further using a Revenue Application query selection. For example, if you would like to only calculate donations to certain designations in your totals, you can create a selection of revenue to those designations only.
  5. Click Save

To read more about Smart Fields, see our Smart Fields Guide here.