Answers.Body: <p>After selecting the entities to search the Group By option~~</p>
  <p><a href="https://i.sstatic.net/oPgjN.png" rel="nofollow noreferrer"><img src="https://i.sstatic.net/oPgjN.png" alt="enter image description here" /></a></p>
  <p>Allows you to choose any of the included entities to group results by</p>
  <p>Contact ID- to return one line per contact
  Activity ID- to return one line per activity- etc</p>
  
Answers.ContentLicense: CC BY-SA 4.0
Answers.CreationDate: 2022-04-12T10:49:57.673Z
Answers.LastActivityDate: 2022-04-12T10:49:57.673Z
Answers.UserDisplayName: Craig Almond
Body: <p>I'n building a report of contact demographics using searchkit for event participants</p>
  <p>Starting with the Contact entity, joining participant and event entities and initially filtering by event type and then event end date.</p>
  <p>All working fine and as expected, and for contacts that have attended more than one event in a quarter it is returning multiple rows for each contact.</p>
  <p><a href="https://i.sstatic.net/UAfNI.png" rel="nofollow noreferrer"><img src="https://i.sstatic.net/UAfNI.png" alt="Screenshot of report results showing 3 rows for one contact" /></a></p>
  <p>What is the simplest way to set the search to return one row per contact? (I'd be able to do this in drupal views, so that's there as a fall back.)</p>
  
Comments.ContentLicense: CC BY-SA 4.0
Comments.CreationDate: 2022-04-06T09:59:51.107Z
Comments.Text: Group By!!!!!!!
  
  Darn it, so busy staring at field transformations I overlooked the blindingly obvious.
Comments.UserDisplayName: Craig Almond
Comments.ContentLicense: CC BY-SA 4.0
Comments.CreationDate: 2022-04-06T18:53:43.040Z
Comments.Text: add that as an Answer Craig
Comments.UserDisplayName: petednz - fuzion
Comments.ContentLicense: CC BY-SA 4.0
Comments.CreationDate: 2022-04-08T15:38:15.323Z
Comments.Text: Cheers Pete, will do after the weekend. Currently not logged into the work system to grab a screenshot.
Comments.UserDisplayName: Craig Almond
Tags: <searchkit>
Title: Return one line per contact in searchkit
ThreadText: # Return one line per contact in searchkit
  
  (Asked by: username_0 on 2022-04-06)
  
  I'n building a report of contact demographics using searchkit for event participants
  
  Starting with the Contact entity, joining participant and event entities and initially filtering by event type and then event end date.
  
  All working fine and as expected, and for contacts that have attended more than one event in a quarter it is returning multiple rows for each contact.
  
  [![Screenshot of report results showing 3 rows for one contact](https://i.sstatic.net/UAfNI.png)](https://i.sstatic.net/UAfNI.png)
  
  What is the simplest way to set the search to return one row per contact? (I'd be able to do this in drupal views, so that's there as a fall back.)
  
  **Tags:** searchkit
  
  > **Comments:**
  > **username_0**: Group By!!!!!!!  Darn it, so busy staring at field transformations I overlooked the blindingly obvious.  
  > **username_1**: add that as an Answer Craig  
  > **username_0**: Cheers Pete, will do after the weekend. Currently not logged into the work system to grab a screenshot.  
  
  ---
  
  ## 1 answers
  
  ### Answer by username_0 on 2022-04-12. Score: 2 | Accepted answer
  
  After selecting the entities to search the Group By option~~
  
  [![enter image description here](https://i.sstatic.net/oPgjN.png)](https://i.sstatic.net/oPgjN.png)
  
  Allows you to choose any of the included entities to group results by
  
  Contact ID- to return one line per contact
  Activity ID- to return one line per activity- etc
  
  
  ---
  
  