Answers.Body: <p>There are several answers to this; I'll give you three!  Use whichever works best for you.</p>
  <p>Note that I originally thought that either <a href="https://civicrm.org/extensions/summary-fields" rel="nofollow noreferrer">Summary Fields</a> or <a href="https://github.com/progressivetech/net.ourpowerbase.search.eventcount" rel="nofollow noreferrer">Event Count custom search</a> extensions would be part of this solution, but neither can count only events in the last 12 months without modification.</p>
  <h3>Easy, best for now</h3>
  <p>Search for active members.  Add them to a group.  Run the event report, filtering by the Active Member group.  If you need to run this report regularly, the Active Member group should be a smart group.</p>
  <h3>Coming soon</h3>
  <p>There's an alpha version of the <a href="https://civicrm.org/blog/josh/overhauling-search-and-reporting-in-civicrm" rel="nofollow noreferrer">Search overhaul</a> that ships (disabled and hidden) in CiviCRM 5.28 (which released three days ago).  This will allow doing searches like you describe in a single search pretty easily.</p>
  
Answers.ContentLicense: CC BY-SA 4.0
Answers.CreationDate: 2020-08-09T14:31:33.617Z
Answers.Text: Thank you very much. I will use the easy option for now, and track the search overhaul as it matures! Thank you Jon.
Answers.UserDisplayName: cylus
Answers.ContentLicense: CC BY-SA 4.0
Answers.CreationDate: 2020-08-09T05:42:17.847Z
Answers.LastActivityDate: 2020-08-09T05:42:17.847Z
Answers.UserDisplayName: Jon G - Megaphone Tech
Body: <p>To be considered a 'voting' member in our organization, you have to be an active member, and also have attended a certain number of events in the past year. I see how to run a membership report, and I see how to run an event report, but how can I search for 'active member' AND 'attended 3 events in the last 12 months'?</p>
  
Tags: <civievent><civimember><reports>
Title: How do you run a membership/event report?
ThreadText: # How do you run a membership/event report?
  
  (Asked by: username_0 on 2020-08-09)
  
  To be considered a 'voting' member in our organization, you have to be an active member, and also have attended a certain number of events in the past year. I see how to run a membership report, and I see how to run an event report, but how can I search for 'active member' AND 'attended 3 events in the last 12 months'?
  
  **Tags:** civievent, civimember, reports
  
  
  ---
  
  ## 1 answers
  
  ### Answer by username_1 on 2020-08-09. Score: 1 | Accepted answer
  
  There are several answers to this; I'll give you three! Use whichever works best for you.
  
  Note that I originally thought that either [Summary Fields](https://civicrm.org/extensions/summary-fields) or [Event Count custom search](https://github.com/progressivetech/net.ourpowerbase.search.eventcount) extensions would be part of this solution, but neither can count only events in the last 12 months without modification.
  
  ### Easy, best for now
  
  Search for active members. Add them to a group. Run the event report, filtering by the Active Member group. If you need to run this report regularly, the Active Member group should be a smart group.
  
  ### Coming soon
  
  There's an alpha version of the [Search overhaul](https://civicrm.org/blog/josh/overhauling-search-and-reporting-in-civicrm) that ships (disabled and hidden) in CiviCRM 5.28 (which released three days ago). This will allow doing searches like you describe in a single search pretty easily.
  
  > **Comments:**
  > **username_0**: Thank you very much. I will use the easy option for now, and track the search overhaul as it matures! Thank you Jon.  
  
  ---
  
  