List report of assignment groups and number of members

[Galam G]

Hello everyone,

I have a requirement to create a list report in Report Designer showing all assignment groups and how many users each group has, like this:

I cannot use "Group by" or other report types such as bar due to additional requirements.

Is there a simple way to achieve this? I appreciate any help!

thank you - Galam

[Kieran Anson]

This is available in Platform Analytics as a pivot report:

[Ankur Bawiskar]

@Galam G 

did you search any OOB report does this for you?

If my response helped please mark it correct and close the thread so that it benefits future readers.

[AakashG1819]

Hlo @Galam G,

Hope you are doing well.

Proposed Solution

In order to achieve this task and to give you an appropriate solution of this problem, I personally tried and implemented it on my Personal Developer Instance so that you can get an appropriate solution as soon as possible. For this, you need to create a Dashboard as per the name that suits you and then create a Report with Pivot as Visualization Type using Platform Analytics. Let me give you the snapshots of Configuration Setup along with the Result of the Report and it seems to be working fine for me and I believe that it'll work for you as well.

Thanks 🙂

Aakash Garg

ServiceNow Developer