Answers.Body: <p>In Drupal you can build Views with Aggregation, which could provide you a list of names and 'count' of events they have attended. Not certain about ability to filter or sort on that value though.</p>
  
Answers.ContentLicense: CC BY-SA 3.0
Answers.CreationDate: 2016-07-06T06:15:02.940Z
Answers.LastActivityDate: 2016-07-06T06:15:02.940Z
Answers.UserDisplayName: petednz - fuzion
Answers.Body: <p>You can easily GROUP BY and COUNT() in mysql - do you have access to mysql? If not you can also put this in to a CiviCRM custom report. </p>
  
  <p>Here's the query:</p>
  
  <p>So below contact_id 2309 participated in 5 events; contact_id 3186 in 2 etc. </p>
  
  <pre><code>    mysql&gt; SELECT contact_id, COUNT(*) from civicrm_participant GROUP BY contact_id HAVING COUNT(*)&gt;1
  +------------+----------+
  | contact_id | COUNT(*) |
  +------------+----------+
  |       2309 |        5 |
  |       3186 |        2 |
  |       3568 |        2 |
  |       5820 |        2 |
  |       7007 |        3 |
  |       7045 |        3 |
  |       7048 |        3 |
  |       7083 |        3 |
  </code></pre>
  
Answers.ContentLicense: CC BY-SA 3.0
Answers.CreationDate: 2016-07-06T20:33:24.390Z
Answers.Text: You'll have to add code. Then register your report. This is still a very good how-to reference: https://alastaira.wordpress.com/2011/03/17/civicrm-creating-a-custom-report/
Answers.UserDisplayName: KarinG - Semper IT
Answers.ContentLicense: CC BY-SA 3.0
Answers.CreationDate: 2016-07-06T20:24:44.727Z
Answers.Text: Where do I go to create a custom report in Civicrm. Only options I see are existing reports...
Answers.UserDisplayName: Yossi
Answers.ContentLicense: CC BY-SA 3.0
Answers.CreationDate: 2016-07-06T02:01:17.623Z
Answers.LastActivityDate: 2016-07-06T02:01:17.623Z
Answers.UserDisplayName: KarinG - Semper IT
Body: <p>Is there a way to track contacts that have registered for more than 1 event within the past 12 months?
  Either through reports or smart groups or any other way?</p>
  
Tags: <contacts><reports>
Title: Track contacts who attended more than 1 event
ThreadText: # Track contacts who attended more than 1 event
  
  (Asked by: username_0 on 2016-07-06)
  
  Is there a way to track contacts that have registered for more than 1 event within the past 12 months?
  Either through reports or smart groups or any other way?
  
  **Tags:** contacts, reports
  
  
  ---
  
  ## 2 answers
  
  ### Answer by username_2 on 2016-07-06. Score: 3 | Accepted answer
  
  You can easily GROUP BY and COUNT() in mysql - do you have access to mysql? If not you can also put this in to a CiviCRM custom report. 
  Here's the query:
  So below contact_id 2309 participated in 5 events; contact_id 3186 in 2 etc. 
      mysql> SELECT contact_id, COUNT(*) from civicrm_participant GROUP BY contact_id HAVING COUNT(*)>1
  +------------+----------+
  | contact_id | COUNT(*) |
  +------------+----------+
  |       2309 |        5 |
  |       3186 |        2 |
  |       3568 |        2 |
  |       5820 |        2 |
  |       7007 |        3 |
  |       7045 |        3 |
  |       7048 |        3 |
  |       7083 |        3 |
  
  > **Comments:**
  > **username_0**: Where do I go to create a custom report in Civicrm. Only options I see are existing reports...  
  > **username_2**: You'll have to add code. Then register your report. This is still a very good how-to reference: https://alastaira.wordpress.com/2011/03/17/civicrm-creating-a-custom-report/  
  
  ---
  
  ### Answer by username_1 on 2016-07-06. Score: 1
  
  In Drupal you can build Views with Aggregation, which could provide you a list of names and 'count' of events they have attended. Not certain about ability to filter or sort on that value though.
  
  
  ---
  
  