Answers.Body: <p>You should have a look at the contribution reports, particularly the SYBUNT one. Also some reports have a filter that let's you search explicitly for first contributions by a donor.</p>
  
Answers.ContentLicense: CC BY-SA 3.0
Answers.CreationDate: 2017-01-29T20:11:15.190Z
Answers.Text: How can I even change the year of "This year" from 2011 which is set by default?
Answers.UserDisplayName: Aivars
Answers.ContentLicense: CC BY-SA 3.0
Answers.CreationDate: 2017-01-30T15:49:29.843Z
Answers.Text: You should be able to slect the current year in the "filter tab" of the sybunt report (at least I was able to do that).
Answers.UserDisplayName: Fabian
Answers.ContentLicense: CC BY-SA 3.0
Answers.CreationDate: 2017-01-26T12:25:16.473Z
Answers.LastActivityDate: 2017-01-26T12:25:16.473Z
Answers.UserDisplayName: Fabian
Answers.Body: <p>Not sure how I would do that with a search, but in general you might want to use CiviRules for donor segmentation? Details can be found here:<a href="https://wiki.civicrm.org/confluence/display/CRMDOC/CiviRules+Cookbook" rel="nofollow noreferrer">https://wiki.civicrm.org/confluence/display/CRMDOC/CiviRules+Cookbook</a> with some examples.</p>
  
Answers.ContentLicense: CC BY-SA 3.0
Answers.CreationDate: 2017-01-26T11:32:33.007Z
Answers.Text: Does CiviRules work good with 4.7.14? Would you kindly share a link that explains how to enable this extension?
Answers.UserDisplayName: Aivars
Answers.ContentLicense: CC BY-SA 3.0
Answers.CreationDate: 2017-01-26T11:34:20.060Z
Answers.Text: Enabling the extension can be done in the standard way, if you do not know how to do this I would suggest you check https://docs.civicrm.org/user/en/stable/introduction/extensions/.
Answers.UserDisplayName: ErikH - CiviCooP
Answers.ContentLicense: CC BY-SA 3.0
Answers.CreationDate: 2017-01-26T11:35:04.793Z
Answers.Text: We have tested CiviRules with 4.6, although I know some organizations have tested it against 4.7. We are likely to upgrade it to 4.7 sometime this year when our customers upgrade.
Answers.UserDisplayName: ErikH - CiviCooP
Answers.ContentLicense: CC BY-SA 3.0
Answers.CreationDate: 2017-01-29T20:12:32.477Z
Answers.Text: Can you expand a bit about 4.7, how does it work according to your information?
Answers.UserDisplayName: Aivars
Answers.ContentLicense: CC BY-SA 3.0
Answers.CreationDate: 2017-01-30T07:07:01.057Z
Answers.Text: That is a strange question to me. I am not a supplier of software products but a sharer of what we made.....if it has been tested with 4.7 it does what the testers have approved? They do not report to me?
Answers.UserDisplayName: ErikH - CiviCooP
Answers.ContentLicense: CC BY-SA 3.0
Answers.CreationDate: 2017-01-26T11:22:11.123Z
Answers.LastActivityDate: 2017-01-26T11:22:11.123Z
Answers.UserDisplayName: ErikH - CiviCooP
Answers.Body: <p>Sounds like a job for <a href="https://civicrm.org/extensions/summary-fields" rel="nofollow noreferrer">Summary Fields</a> extension</p>
  
  <p>It'll do lots of roll up calculations and store them to make a lot of contribution-related searches of contacts much faster.</p>
  
  <p>Then you can look for contacts that have a value of "Date of Last Contribution" within the last 3 months, and have the value "Total Contributions in the Last 12 Months" equal to the amount "Amount of the last Contribution"  - you can do that with the search builder for example.</p>
  
Answers.ContentLicense: CC BY-SA 3.0
Answers.CreationDate: 2017-01-27T14:20:07.160Z
Answers.Text: The problem with this scenario is that "Total Contributions in the Last 12 Months" returns the donation amount (sum), not the times of donations (count).
  
  What I would need for this purpose is the option **Count of Contributions in the Last 12 month** in Summary Fields.
Answers.UserDisplayName: Aivars
Answers.ContentLicense: CC BY-SA 3.0
Answers.CreationDate: 2017-01-27T20:38:34.847Z
Answers.Text: You're right, so here's another way - look for where the Total Contributions in the Last 12 Months = The amount of the last contribution. Updating my answer above.
Answers.UserDisplayName: Alan Dixon
Answers.ContentLicense: CC BY-SA 3.0
Answers.CreationDate: 2017-01-29T20:32:40.747Z
Answers.Text: I get the idea, but I don't understand how can I search for Contacts whose **Total Contributions in the Last 12 Months** match **The Amount of the Last Contribution** using Search builder (or any other CiviCRM tool for that matter). Could you please explain?
Answers.UserDisplayName: Aivars
Answers.ContentLicense: CC BY-SA 3.0
Answers.CreationDate: 2017-01-30T16:46:20.470Z
Answers.Text: You're right again, I was indulging in wishful thinking, there's no way I can see how to compare two fields in those interfaces. Maybe back to working with the extension maintainers to see how to add a new field containing the number of contributions in the past year?
Answers.UserDisplayName: Alan Dixon
Answers.ContentLicense: CC BY-SA 3.0
Answers.CreationDate: 2017-01-26T17:38:17.777Z
Answers.LastActivityDate: 2017-01-27T20:40:01.007Z
Answers.LastEditDate: 2017-01-27T20:40:01.007Z
Answers.UserDisplayName: Alan Dixon
Answers.Body: <p>I'm not sure if this is possible with one search but other approach could be to save the two searches separately as smart groups and then build a new search for contacts that are in the two groups at once.</p>
  
Answers.ContentLicense: CC BY-SA 3.0
Answers.CreationDate: 2017-01-26T11:50:33.310Z
Answers.Text: Can you name what criteria to use for this purpose in each search?
Answers.UserDisplayName: Aivars
Answers.ContentLicense: CC BY-SA 3.0
Answers.CreationDate: 2017-01-26T12:06:54.537Z
Answers.Text: I tried to figure out how to create a group which contains contacts with donations in last 30 days and NOT the contacts with donation in 11 months before that.
  
  https://i.sstatic.net/e3dwR.jpg
Answers.UserDisplayName: Aivars
Answers.ContentLicense: CC BY-SA 3.0
Answers.CreationDate: 2017-01-26T12:07:09.753Z
Answers.Text: I think here you can find some more hints http://civicrm.stackexchange.com/questions/114/how-do-i-search-for-contacts-with-no-contributions
Answers.UserDisplayName: Francesc Bassas i Bullich
Answers.ContentLicense: CC BY-SA 3.0
Answers.CreationDate: 2017-01-27T14:29:52.580Z
Answers.Text: Nice hints, but does not help to solve my problem. :(
Answers.UserDisplayName: Aivars
Answers.ContentLicense: CC BY-SA 3.0
Answers.CreationDate: 2017-01-26T11:37:04.580Z
Answers.LastActivityDate: 2017-01-26T11:37:04.580Z
Answers.UserDisplayName: Francesc Bassas i Bullich
Body: <p>How can I build a search for contacts that match two criteria?</p>
  
  <p>1) The contact has contributed in the last 30 days; </p>
  
  <p>AND</p>
  
  <p>2) The contact has not contributed another donation within the last 12 months.</p>
  
  <p>In other words, I'd like to select people who have donated for the first time during last 12 months.</p>
  
Tags: <search>
Title: How can I find contacts with only 1 contribution during last 12 months?
ThreadText: # How can I find contacts with only 1 contribution during last 12 months?
  
  (Asked by: username_0 on 2017-01-26)
  
  How can I build a search for contacts that match two criteria?
  
  1) The contact has contributed in the last 30 days;
  
  AND
  
  2) The contact has not contributed another donation within the last 12 months.
  
  In other words, I'd like to select people who have donated for the first time during last 12 months.
  
  **Tags:** search
  
  
  ---
  
  ## 4 answers
  
  ### Answer by username_1 on 2017-01-26. Score: 1
  
  You should have a look at the contribution reports, particularly the SYBUNT one. Also some reports have a filter that let's you search explicitly for first contributions by a donor.
  
  > **Comments:**
  > **username_0**: How can I even change the year of "This year" from 2011 which is set by default?  
  > **username_1**: You should be able to slect the current year in the "filter tab" of the sybunt report (at least I was able to do that).  
  
  ---
  
  ### Answer by username_2 on 2017-01-26. Score: 1
  
  Not sure how I would do that with a search, but in general you might want to use CiviRules for donor segmentation? Details can be found here:<https://wiki.civicrm.org/confluence/display/CRMDOC/CiviRules+Cookbook> with some examples.
  
  > **Comments:**
  > **username_0**: Does CiviRules work good with 4.7.14? Would you kindly share a link that explains how to enable this extension?  
  > **username_2**: Enabling the extension can be done in the standard way, if you do not know how to do this I would suggest you check https://docs.civicrm.org/user/en/stable/introduction/extensions/.  
  > **username_2**: We have tested CiviRules with 4.6, although I know some organizations have tested it against 4.7. We are likely to upgrade it to 4.7 sometime this year when our customers upgrade.  
  > **username_0**: Can you expand a bit about 4.7, how does it work according to your information?  
  > **username_2**: That is a strange question to me. I am not a supplier of software products but a sharer of what we made.....if it has been tested with 4.7 it does what the testers have approved? They do not report to me?  
  
  ---
  
  ### Answer by username_3 on 2017-01-26. Score: 1
  
  Sounds like a job for [Summary Fields](https://civicrm.org/extensions/summary-fields) extension
  
  It'll do lots of roll up calculations and store them to make a lot of contribution-related searches of contacts much faster.
  
  Then you can look for contacts that have a value of "Date of Last Contribution" within the last 3 months, and have the value "Total Contributions in the Last 12 Months" equal to the amount "Amount of the last Contribution" - you can do that with the search builder for example.
  
  > **Comments:**
  > **username_0**: The problem with this scenario is that "Total Contributions in the Last 12 Months" returns the donation amount (sum), not the times of donations (count).  What I would need for this purpose is the option **Count of Contributions in the Last 12 month** in Summary Fields.  
  > **username_3**: You're right, so here's another way - look for where the Total Contributions in the Last 12 Months = The amount of the last contribution. Updating my answer above.  
  > **username_0**: I get the idea, but I don't understand how can I search for Contacts whose **Total Contributions in the Last 12 Months** match **The Amount of the Last Contribution** using Search builder (or any other CiviCRM tool for that matter). Could you please explain?  
  > **username_3**: You're right again, I was indulging in wishful thinking, there's no way I can see how to compare two fields in those interfaces. Maybe back to working with the extension maintainers to see how to add a new field containing the number of contributions in the past year?  
  
  ---
  
  ### Answer by username_4 on 2017-01-26. Score: 0
  
  I'm not sure if this is possible with one search but other approach could be to save the two searches separately as smart groups and then build a new search for contacts that are in the two groups at once.
  
  > **Comments:**
  > **username_0**: Can you name what criteria to use for this purpose in each search?  
  > **username_0**: I tried to figure out how to create a group which contains contacts with donations in last 30 days and NOT the contacts with donation in 11 months before that.  https://i.sstatic.net/e3dwR.jpg  
  > **username_4**: I think here you can find some more hints http://civicrm.stackexchange.com/questions/114/how-do-i-search-for-contacts-with-no-contributions  
  > **username_0**: Nice hints, but does not help to solve my problem. :(  
  
  ---
  
  