Can you Make a Report, that provides the Number of Employees (relationships) for every Employer?

Question

The report would simply be a listing of employers and the number of employees or current relationships that employer has.

It's the same number we would get from going to an organizations, clicking on relationships and seeing the number of current relationships.

This is what I see in Search Kit: (civi 5.42.1)

SearchKit is changing fast so perhaps a/ state your version b/ get on the latest if not already — petednz - fuzion, Commented Nov 11, 2021 at 5:59
True - there are notable SearchKit changes with every release currently. My answer below was from dmaster which is currently 5.45.alpha1 — Aidan, Commented Nov 11, 2021 at 9:29

Aidan · Accepted Answer · 2021-11-11 09:34:25Z

2

You can with SearchKit... Try this link on dmaster (Note all the configuration is in the link so it won't get wiped out by a dmaster refresh.)

answered Nov 10, 2021 at 22:20

Aidan♦

13.7k1 gold badge16 silver badges40 bronze badges

I was able to follow until field transformations - mine only shows contact ID and display name. I added a screenshot in original question
– themak
Commented Nov 10, 2021 at 23:08
You need to add 'Group By' - note my screenshot and link have a 'Group by Contact ID'. Add that and you should get 'Count' available in the field transformations section.
– Aidan ♦
Commented Nov 11, 2021 at 9:22
I did, must be something with my install. I got it to work, just looks different than yours. Thanks so much!
– themak
Commented Nov 11, 2021 at 15:50

Add a comment |

1 Answer 1