Report for the count of users for groups.

Kruthik M Shiva
Tera Contributor

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

6 REPLIES 6

Matt S1
Tera Contributor

Hello! 

Maybe impossible but is there a way to get the user names to display into the value fields instead of the numbers.

Hi @Matt S1 ,

 

No, that is not possible.

 

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

 

Best regards

Anders

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

Best regards
Anders

Rising star 2024
MVP 2025
linkedIn: https://www.linkedin.com/in/andersskovbjerg/