Report for the count of users for groups.

[Kruthik M Shiva]

Hi All,
I have a requirement to create a report on sys_user_grmember table and I filtered only 4 custom groups created by me now I need to get total count of members in 4 groups, if there are any duplicates in any group it should only count as 1.
e.g.: If person A is part of 1&2 groups. It should count as only one not 2. How to configure this Please do share any pointers on this.
Thanks in advance.
Kruthik Shivaprasad

[AndersBGS]

Hi @Kruthik M Shiva ,

I would suggest you to create a report based on the sys_user_grmember table with the condition: 

Off course, hardware and software should be changed to your respective groups.

If you then create a "pivot table" report, then you will get below view:

To get a count distinct, I do not see any perfect solutions. 

If my answer has helped with your question, please mark my answer as accepted solution and give a thumb up.

Best regards

Anders

[AndersBGS]

Hi @Kruthik M Shiva 

If my answer has helped with your question, please mark my answer as accepted solution.

Best regards

Anders

[Dr Atul G- LNG]

Hi @Kruthik M Shiva 

Greetings!!

The best way to get the details is Pivot Table and perfectly suggested by @AndersBGS , please create the report type is Pivot and add fields as columns and Rows.

If person A is part of 1&2 groups. It should count as only one not 2. How to configure this Please do share any pointers on this.

Atul: I think it is not possible OOTB, as it required the check and standard reporting did not provide the same.

[Dr Atul G- LNG]

Hi @Kruthik M Shiva