Answers.Body: <p>In SearchKit, you can search by Contact with required Activity or Contribution, group by Contact ID and then use the Count field transformation on the Activity or Contribution ID, then add Having Count &gt; N.</p>
  
Answers.ContentLicense: CC BY-SA 4.0
Answers.CreationDate: 2022-10-17T14:02:48.760Z
Answers.LastActivityDate: 2022-10-17T14:29:40.727Z
Answers.LastEditDate: 2022-10-17T14:29:40.727Z
Answers.UserDisplayName: Lars SG
Body: <p>WP 6 Civi 5.51</p>
  <p>We'd like to  &quot;Find contacts who have signed x number of petitions&quot;
  It seems to me that built in petitions, activities, custom field/profiles cannot provide this.</p>
  <p>Contributions is a possibility with financial type = petition signature as there are a range of aggregate searches. However contribution pages/forms don't lend themselves to this because of $amounts etc, unless I am missing something?</p>
  <p>The new form builder might solve the $label issue but doesn't seem to offer contribution fields.</p>
  <p>Caldera defunct, Ninja no contribs, Gravity no contribs.</p>
  <p>Anything I've missed?</p>
  
Tags: <forms><petition>
Title: How to aggregate petition signers
ThreadText: # How to aggregate petition signers
  
  (Asked by: username_0 on 2022-10-17)
  
  WP 6 Civi 5.51
  
  We'd like to "Find contacts who have signed x number of petitions"
  It seems to me that built in petitions, activities, custom field/profiles cannot provide this.
  
  Contributions is a possibility with financial type = petition signature as there are a range of aggregate searches. However contribution pages/forms don't lend themselves to this because of $amounts etc, unless I am missing something?
  
  The new form builder might solve the $label issue but doesn't seem to offer contribution fields.
  
  Caldera defunct, Ninja no contribs, Gravity no contribs.
  
  Anything I've missed?
  
  **Tags:** forms, petition
  
  
  ---
  
  ## 1 answers
  
  ### Answer by username_1 on 2022-10-17. Score: 2 | Accepted answer
  
  In SearchKit, you can search by Contact with required Activity or Contribution, group by Contact ID and then use the Count field transformation on the Activity or Contribution ID, then add Having Count > N.
  
  
  ---
  
  