2

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

Improve this question
3
  • 1
    Group By!!!!!!! Darn it, so busy staring at field transformations I overlooked the blindingly obvious.
    – Craig Almond
    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.
    – Craig Almond
    Commented Apr 8, 2022 at 15:38

1 Answer 1

Reset to default
2

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

Improve this answer

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.