Answers.Body: <p>AGH Strategies has written a report to do this, which is available as an extension: <a href="https://civicrm.org/extensions/donor-tier-report" rel="nofollow noreferrer">Donor Tier Report</a>.</p>
  
Answers.ContentLicense: CC BY-SA 3.0
Answers.CreationDate: 2017-11-02T20:04:37.483Z
Answers.LastActivityDate: 2017-11-02T20:04:37.483Z
Answers.UserDisplayName: Jon G - Megaphone Tech
Answers.Body: <p>Yes I would use Aggregation in Views - and I would base that on using Summary Fields extension.</p>
  
Answers.ContentLicense: CC BY-SA 3.0
Answers.CreationDate: 2017-08-28T20:42:58.177Z
Answers.LastActivityDate: 2017-08-28T20:42:58.177Z
Answers.UserDisplayName: petednz - fuzion
Answers.Body: <p>you could use the <a href="https://civicrm.org/extensions/summary-fields" rel="nofollow noreferrer">Summary fields Extension</a>. Also, CiviCRM comes with a custom search (/civicrm/contact/search/custom?csid=2&amp;reset=1) that would allow you to search for contacts that meet the criteria and create smart groups as you suggested.</p>
  
Answers.ContentLicense: CC BY-SA 3.0
Answers.CreationDate: 2017-04-03T21:17:37.340Z
Answers.Text: Thank you!  However, my question isn't about how to create the smart groups.  Instead, it's how to run a report that has a `GROUP BY` using the groups.
Answers.UserDisplayName: Jon G - Megaphone Tech
Answers.ContentLicense: CC BY-SA 3.0
Answers.CreationDate: 2017-03-31T08:56:33.960Z
Answers.LastActivityDate: 2017-03-31T08:56:33.960Z
Answers.UserDisplayName: Fabian
Answers.Body: <p>Personally I would probably always use CiviRules (<a href="https://civicrm.org/extensions/civirules" rel="nofollow noreferrer">https://civicrm.org/extensions/civirules</a>) to do donor segmentation, allowing you to have groups to report on. </p>
  
  <p>There is an example of donor segmentation with CiviRules on <a href="https://wiki.civicrm.org/confluence/display/CRMDOC/CiviRules+Example+Donor+Classification" rel="nofollow noreferrer">https://wiki.civicrm.org/confluence/display/CRMDOC/CiviRules+Example+Donor+Classification</a></p>
  
Answers.ContentLicense: CC BY-SA 3.0
Answers.CreationDate: 2017-04-30T09:41:00.033Z
Answers.LastActivityDate: 2017-04-30T09:41:00.033Z
Answers.UserDisplayName: ErikH - CiviCooP
Body: <p>Let's say I have these groups of donors:</p>
  
  <ul>
  <li>Small donor, gave &lt; $100 in the past year.</li>
  <li>Medium donor, gave $100-500 in the past year.</li>
  <li>Major donor, gave > $500 in the past year.</li>
  </ul>
  
  <p>What's the best way to get a count of all these in one place?  My best thought is to create smart groups - then I'd need a report of "Counts by Group".  Does such a thing exist?  What if I use aggregation with a Drupal View?</p>
  
Tags: <civireport><custom-reports>
Title: Getting counts of donors grouped into categories by giving amount
ThreadText: # Getting counts of donors grouped into categories by giving amount
  
  (Asked by: username_0 on 2017-03-30)
  
  Let's say I have these groups of donors:
  
  * Small donor, gave < $100 in the past year.
  * Medium donor, gave $100-500 in the past year.
  * Major donor, gave > $500 in the past year.
  
  What's the best way to get a count of all these in one place? My best thought is to create smart groups - then I'd need a report of "Counts by Group". Does such a thing exist? What if I use aggregation with a Drupal View?
  
  **Tags:** civireport, custom-reports
  
  
  ---
  
  ## 4 answers
  
  ### Answer by username_0 on 2017-11-02. Score: 1 | Accepted answer
  
  AGH Strategies has written a report to do this, which is available as an extension: [Donor Tier Report](https://civicrm.org/extensions/donor-tier-report).
  
  
  ---
  
  ### Answer by username_1 on 2017-08-28. Score: 0
  
  Yes I would use Aggregation in Views - and I would base that on using Summary Fields extension.
  
  
  ---
  
  ### Answer by username_2 on 2017-03-31. Score: 0
  
  you could use the [Summary fields Extension](https://civicrm.org/extensions/summary-fields). Also, CiviCRM comes with a custom search (/civicrm/contact/search/custom?csid=2&reset=1) that would allow you to search for contacts that meet the criteria and create smart groups as you suggested.
  
  > **Comments:**
  > **username_0**: Thank you!  However, my question isn't about how to create the smart groups.  Instead, it's how to run a report that has a `GROUP BY` using the groups.  
  
  ---
  
  ### Answer by username_3 on 2017-04-30. Score: 0
  
  Personally I would probably always use CiviRules (<https://civicrm.org/extensions/civirules>) to do donor segmentation, allowing you to have groups to report on.
  
  There is an example of donor segmentation with CiviRules on <https://wiki.civicrm.org/confluence/display/CRMDOC/CiviRules+Example+Donor+Classification>
  
  
  ---
  
  