Answers.Body: <p>I think you can get what you want with the "Event Participants Report" (under the Events > Event Reports Menu). In the "Sorting" tab, just tick the box for "Section Header / Group By" against "Last Name, First Name". You use the "Filters" tab to restrict to a particular time period, set of events etc.</p>
  
  <p>In general if I can't do something off the shelf in CiviCRM then I export a search result or report to Excel and manipulate it there. A lot easier than writing a new report. In this case I would have used the Subtotal function in Excel if I couldn't have done it within CiviCRM.</p>
  
Answers.ContentLicense: CC BY-SA 4.0
Answers.CreationDate: 2018-11-12T18:26:55.670Z
Answers.Text: Mick, Thanks for that.  Yes, I have frequently imported stuff into Excel, and then manipulated it from there, but I really want to learn how to use the Civi Reports more...
Answers.UserDisplayName: rickparisi
Answers.ContentLicense: CC BY-SA 4.0
Answers.CreationDate: 2018-11-12T18:34:21.143Z
Answers.Text: So I did what you said, and I see a report that lists every participant.  Next to each one's name is the number of events they attended in parenthesis.  That is getting me close, but I am missing something.  I would like to be able to sort on the number of events, but since the total number of events is not a data field, I don't know how to do that.  Am I missing something?
Answers.UserDisplayName: rickparisi
Answers.ContentLicense: CC BY-SA 4.0
Answers.CreationDate: 2018-11-12T23:53:01.423Z
Answers.Text: I don't think you would be able to do that in the CiviCRM report - as you say it only allows sorting by the data fields from the participant record. I think the only way to do this is the export to Excel (which gets the report without the subtotals, use the Excel subtotal tool and then manipulate it a bit (I played a bit filtering out blanks in the first column then sorting by the second column, but you probably need to do a bit more that to be able to use it).
Answers.UserDisplayName: Mick Kahn
Answers.ContentLicense: CC BY-SA 4.0
Answers.CreationDate: 2018-11-09T14:56:04.597Z
Answers.LastActivityDate: 2018-11-09T14:56:04.597Z
Answers.UserDisplayName: Mick Kahn
Body: <p>I would like a report that lists the number of events attended by (or registered by) each participant.  This seems like something that a lot of organizations would find useful, yet I can't seem to find anything even close to this that I could customize into what I'm looking for.  Am I missing something, or is there no such report in existence.  If not, any suggestions.
  Thanks,
  Rick</p>
  
Comments.ContentLicense: CC BY-SA 4.0
Comments.CreationDate: 2018-11-09T19:31:11.083Z
Comments.Text: if you are on Drupal then Views and 'aggregation' could quickly give you the count of events each contact has attended, if that is what you want and if you can't get it easily via civi report
Comments.UserDisplayName: petednz - fuzion
Comments.ContentLicense: CC BY-SA 4.0
Comments.CreationDate: 2018-11-12T18:37:53.370Z
Comments.Text: Thanks, but I am not on Drupal.
Comments.UserDisplayName: rickparisi
Tags: <reports><custom-reports>
Title: Report for number of events attended by each person
ThreadText: # Report for number of events attended by each person
  
  (Asked by: username_0 on 2018-11-08)
  
  I would like a report that lists the number of events attended by (or registered by) each participant. This seems like something that a lot of organizations would find useful, yet I can't seem to find anything even close to this that I could customize into what I'm looking for. Am I missing something, or is there no such report in existence. If not, any suggestions.
  Thanks,
  Rick
  
  **Tags:** reports, custom-reports
  
  > **Comments:**
  > **username_1**: if you are on Drupal then Views and 'aggregation' could quickly give you the count of events each contact has attended, if that is what you want and if you can't get it easily via civi report  
  > **username_0**: Thanks, but I am not on Drupal.  
  
  ---
  
  ## 1 answers
  
  ### Answer by username_2 on 2018-11-09. Score: 3
  
  I think you can get what you want with the "Event Participants Report" (under the Events > Event Reports Menu). In the "Sorting" tab, just tick the box for "Section Header / Group By" against "Last Name, First Name". You use the "Filters" tab to restrict to a particular time period, set of events etc.
  
  In general if I can't do something off the shelf in CiviCRM then I export a search result or report to Excel and manipulate it there. A lot easier than writing a new report. In this case I would have used the Subtotal function in Excel if I couldn't have done it within CiviCRM.
  
  > **Comments:**
  > **username_0**: username_2, Thanks for that.  Yes, I have frequently imported stuff into Excel, and then manipulated it from there, but I really want to learn how to use the Civi Reports more...  
  > **username_0**: So I did what you said, and I see a report that lists every participant.  Next to each one's name is the number of events they attended in parenthesis.  That is getting me close, but I am missing something.  I would like to be able to sort on the number of events, but since the total number of events is not a data field, I don't know how to do that.  Am I missing something?  
  > **username_2**: I don't think you would be able to do that in the CiviCRM report - as you say it only allows sorting by the data fields from the participant record. I think the only way to do this is the export to Excel (which gets the report without the subtotals, use the Excel subtotal tool and then manipulate it a bit (I played a bit filtering out blanks in the first column then sorting by the second column, but you probably need to do a bit more that to be able to use it).  
  
  ---
  
  