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

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.)

  • 1
    Group By!!!!!!! Darn it, so busy staring at field transformations I overlooked the blindingly obvious. Commented Apr 6, 2022 at 9:59
  • add that as an Answer Craig
    – petednz - fuzion
    Commented Apr 6, 2022 at 18:53
  • Cheers Pete, will do after the weekend. Currently not logged into the work system to grab a screenshot. Commented Apr 8, 2022 at 15:38

1 Answer 1


After selecting the entities to search the Group By option~~

enter image description here

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

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.