Answers.Body: <p>I'm unaware of a way to do this with out-of-the-box features in CiviCRM. However we recently did this for a client by extending the Summary Fields extension, defining a Summary Field that calculates Yes/No based on whether the contact has at least one completed contributions of a certain Financial Type in each of the 5 most recent years. Sounds almost exactly like what you describe.</p>
  
  <ul>
  <li>Summary Fields: <a href="https://civicrm.org/extensions/summary-fields" rel="nofollow noreferrer">https://civicrm.org/extensions/summary-fields</a></li>
  <li>Joinery's "PAAO Summary Fields":
  <a href="https://github.com/twomice/com.joineryhq.paaosumfields" rel="nofollow noreferrer">https://github.com/twomice/com.joineryhq.paaosumfields</a> (this defines the Summary Field called "Loyalty Discount", which is currently not doing what's described above; but in an earlier version it was doing just that: <a href="https://github.com/twomice/com.joineryhq.paaosumfields/commit/234603ffcbad013e4ad37b6494625be4f1606bf3" rel="nofollow noreferrer">https://github.com/twomice/com.joineryhq.paaosumfields/commit/234603ffcbad013e4ad37b6494625be4f1606bf3</a>)</li>
  </ul>
  
  <p>So my answer here would be "yes, totally possible by extending Summary Fields".</p>
  
Answers.ContentLicense: CC BY-SA 4.0
Answers.CreationDate: 2019-06-25T20:56:56.750Z
Answers.Text: Thanks, very interesting, will give it a try and report back.
Answers.UserDisplayName: Andy Clark
Answers.ContentLicense: CC BY-SA 4.0
Answers.CreationDate: 2019-06-26T15:00:30.897Z
Answers.Text: Great, I'm looking forward to your findings.
Answers.UserDisplayName: TwoMice
Answers.ContentLicense: CC BY-SA 4.0
Answers.CreationDate: 2019-06-25T20:17:36.490Z
Answers.LastActivityDate: 2019-06-25T20:17:36.490Z
Answers.UserDisplayName: TwoMice
Body: <p>We'd like to acknowledge donors who have given continuously for (say) 5 years. Let's say 'continuous' means at least one donation in a year. How could these contacts be identified and reported?  I've looked at all the contribution reports, including the Powerbase report extension, and thought about smart groups but I can't see a way of detecting these.  There is the 'Recurring contributions' report but that doesn't do it as these donations may not necessarily be defined as recurring contributions.  We're using Drupal so could use Drupal Views, but I'm not sure that would be able to do it.</p>
  
Tags: <civireport><contributions>
Title: How to identify and report on donor anniversaries?
ThreadText: # How to identify and report on donor anniversaries?
  
  (Asked by: username_0 on 2019-06-25)
  
  We'd like to acknowledge donors who have given continuously for (say) 5 years. Let's say 'continuous' means at least one donation in a year. How could these contacts be identified and reported? I've looked at all the contribution reports, including the Powerbase report extension, and thought about smart groups but I can't see a way of detecting these. There is the 'Recurring contributions' report but that doesn't do it as these donations may not necessarily be defined as recurring contributions. We're using Drupal so could use Drupal Views, but I'm not sure that would be able to do it.
  
  **Tags:** civireport, contributions
  
  
  ---
  
  ## 1 answers
  
  ### Answer by username_1 on 2019-06-25. Score: 2
  
  I'm unaware of a way to do this with out-of-the-box features in CiviCRM. However we recently did this for a client by extending the Summary Fields extension, defining a Summary Field that calculates Yes/No based on whether the contact has at least one completed contributions of a certain Financial Type in each of the 5 most recent years. Sounds almost exactly like what you describe.
  
  * Summary Fields: <https://civicrm.org/extensions/summary-fields>
  * Joinery's "PAAO Summary Fields":
    <https://github.com/twomice/com.joineryhq.paaosumfields> (this defines the Summary Field called "Loyalty Discount", which is currently not doing what's described above; but in an earlier version it was doing just that: <https://github.com/twomice/com.joineryhq.paaosumfields/commit/234603ffcbad013e4ad37b6494625be4f1606bf3>)
  
  So my answer here would be "yes, totally possible by extending Summary Fields".
  
  > **Comments:**
  > **username_0**: Thanks, very interesting, will give it a try and report back.  
  > **username_1**: Great, I'm looking forward to your findings.  
  
  ---
  
  