Answers.Body: <p>Maybe the extension <a href="https://civicrm.org/extensions/summary-fields" rel="nofollow noreferrer">summary fields</a> could be used as a base. Even though it probably does not do exactly what you want, it may be easier to build up on it insted of developing something completely new.</p>
  
  <p>Or you could use the <a href="https://civicrm.org/extensions/sql-tasks-extension-configurable-recurring-tasks" rel="nofollow noreferrer">SQL-Task Extension</a>.</p>
  
Answers.ContentLicense: CC BY-SA 4.0
Answers.CreationDate: 2020-03-04T23:50:44.887Z
Answers.Text: I was going to suggest adding this feature to Summary Fields - seems a great fit.
Answers.UserDisplayName: petednz - fuzion
Answers.ContentLicense: CC BY-SA 4.0
Answers.CreationDate: 2020-03-04T13:53:15.543Z
Answers.LastActivityDate: 2020-03-04T13:53:15.543Z
Answers.UserDisplayName: Fabian
Answers.Body: <p>Alternative with very little coding:</p>
  
  <ol>
  <li>create a custom field on individual Number of Productions</li>
  <li>create a CiviRule (trigger activity is added, condition activity type = xxxx)</li>
  <li>develop a specific action to add 1 to the number of productions (max 2 hrs of work)</li>
  <li>search on the custom field</li>
  </ol>
  
Answers.ContentLicense: CC BY-SA 4.0
Answers.CreationDate: 2020-03-05T15:42:03.550Z
Answers.Text: Nice idea Erik. That provides a custom field they can search and react to (send mailings to those whit over 5 attendances in Wales etc). Big thanks
Answers.UserDisplayName: Oliver Gibson
Answers.ContentLicense: CC BY-SA 4.0
Answers.CreationDate: 2020-03-05T15:45:43.593Z
Answers.Text: Anytime Olly :-)
Answers.UserDisplayName: ErikH - CiviCooP
Answers.ContentLicense: CC BY-SA 4.0
Answers.CreationDate: 2020-03-04T13:57:06.800Z
Answers.LastActivityDate: 2020-03-04T13:57:06.800Z
Answers.UserDisplayName: ErikH - CiviCooP
Answers.Body: <p>To me this sounds like a job for pivot tables:</p>
  
  <ol>
  <li>Search - Find Activities.</li>
  <li>Choose Export from the options dropdown.</li>
  <li>Open the file in excel and make a pivot table, with the contact on the row, and count of activity id as the data value. Sort the pivot by count.</li>
  </ol>
  
Answers.ContentLicense: CC BY-SA 4.0
Answers.CreationDate: 2020-03-04T23:51:11.013Z
Answers.Text: are pivot tables in core now - or still only via some Adv Report extension?
Answers.UserDisplayName: petednz - fuzion
Answers.ContentLicense: CC BY-SA 4.0
Answers.CreationDate: 2020-03-04T23:55:43.463Z
Answers.Text: They're in Excel, and probably libreoffice. There is a type of pivot in the Extended Reports extension but it wouldn't solve this particular question.
Answers.UserDisplayName: Demerit
Answers.ContentLicense: CC BY-SA 4.0
Answers.CreationDate: 2020-03-05T01:50:25.847Z
Answers.Text: apologies, i must have only read every other line in the above :-) but yes, some are in Extended Reports
Answers.UserDisplayName: petednz - fuzion
Answers.ContentLicense: CC BY-SA 4.0
Answers.CreationDate: 2020-03-05T02:03:05.677Z
Answers.Text: No apology needed! If pivot tables were in core that would be awesome. They are my most used feature in excel. Well, maybe "fill down" is, but pivot tables second.
Answers.UserDisplayName: Demerit
Answers.ContentLicense: CC BY-SA 4.0
Answers.CreationDate: 2020-03-04T15:37:38.983Z
Answers.LastActivityDate: 2020-03-04T15:37:38.983Z
Answers.UserDisplayName: Demerit
Body: <p>We have a client who will be recording people who attend theatre productions. These attendances will be recorded as CRM activities (imported in bulk). The client would then like to search for people who have attended x activities (maybe over a set time period). Then group them and contact them. </p>
  
  <p>CiviCRM would be very good at telling us who attended one or more theatre attendance activities. But not mutiple. Considered smart groups, custom searches, search builder, extended reports etc. </p>
  
  <p>We think a custom extension may be needed for this. Any ideas would be appreciated.</p>
  
  <p>Olly</p>
  
Comments.ContentLicense: CC BY-SA 4.0
Comments.CreationDate: 2020-03-05T01:50:53.837Z
Comments.Text: depending on your CMS, a Drupal View may give you v much what you need
Comments.UserDisplayName: petednz - fuzion
Tags: <activities>
Title: Finding people with multiple activities
ThreadText: # Finding people with multiple activities
  
  (Asked by: username_0 on 2020-03-04)
  
  We have a client who will be recording people who attend theatre productions. These attendances will be recorded as CRM activities (imported in bulk). The client would then like to search for people who have attended x activities (maybe over a set time period). Then group them and contact them.
  
  CiviCRM would be very good at telling us who attended one or more theatre attendance activities. But not mutiple. Considered smart groups, custom searches, search builder, extended reports etc.
  
  We think a custom extension may be needed for this. Any ideas would be appreciated.
  
  Olly
  
  **Tags:** activities
  
  > **Comments:**
  > **username_1**: depending on your CMS, a Drupal View may give you v much what you need  
  
  ---
  
  ## 3 answers
  
  ### Answer by username_2 on 2020-03-04. Score: 2
  
  Maybe the extension [summary fields](https://civicrm.org/extensions/summary-fields) could be used as a base. Even though it probably does not do exactly what you want, it may be easier to build up on it insted of developing something completely new.
  
  Or you could use the [SQL-Task Extension](https://civicrm.org/extensions/sql-tasks-extension-configurable-recurring-tasks).
  
  > **Comments:**
  > **username_1**: I was going to suggest adding this feature to Summary Fields - seems a great fit.  
  
  ---
  
  ### Answer by username_3 on 2020-03-04. Score: 2
  
  Alternative with very little coding:
  
  1. create a custom field on individual Number of Productions
  2. create a CiviRule (trigger activity is added, condition activity type = xxxx)
  3. develop a specific action to add 1 to the number of productions (max 2 hrs of work)
  4. search on the custom field
  
  > **Comments:**
  > **username_0**: Nice idea Erik. That provides a custom field they can search and react to (send mailings to those whit over 5 attendances in Wales etc). Big thanks  
  > **username_3**: Anytime Olly :-)  
  
  ---
  
  ### Answer by username_4 on 2020-03-04. Score: 1
  
  To me this sounds like a job for pivot tables:
  
  1. Search - Find Activities.
  2. Choose Export from the options dropdown.
  3. Open the file in excel and make a pivot table, with the contact on the row, and count of activity id as the data value. Sort the pivot by count.
  
  > **Comments:**
  > **username_1**: are pivot tables in core now - or still only via some Adv Report extension?  
  > **username_4**: They're in Excel, and probably libreoffice. There is a type of pivot in the Extended Reports extension but it wouldn't solve this particular question.  
  > **username_1**: apologies, i must have only read every other line in the above :-) but yes, some are in Extended Reports  
  > **username_4**: No apology needed! If pivot tables were in core that would be awesome. They are my most used feature in excel. Well, maybe "fill down" is, but pivot tables second.  
  
  ---
  
  