Note: These steps require the Smart Field System role.

First, build your Smart Field:
  1. Go to Administration > Smart Field.
  2. Click Add.
  3. Select constituent revenue giving years and click Ok.
  4. Name your smart field number of years a member
  5. On the parameters tab, select distinct giving years.
  6. Don't enter dates if you are looking for the total number of years they have been a member.
  7. Under revenue types, select membership, as seen below.
  8. Click Save.
  9. Find your smart field in the list of smart fields.
  10. Click on the smart field.
  11. Click Start Process.
Smart Field

Next, build your query:
  1. Go to Analysis > Information Library.  Click Add an ad-hoc query.
  2. Select constituents as the source view and click Ok.
  3. On the left, click the plus sign next to the Smart Fields folder.
  4. Click on the name of your smart field on the left.
  5. In the middle, click Value and move to Include records where.
  6. Set the criteria to equal to the number of years of membership you are looking for, as seen below.
  7. Click Ok.
  8. Go to the Set Save Options tab, name your query and save it.
Number of Years a Member Query