Report to display users with less than 10 skills

[CV1]

Hello All,

Looking for help to create a report that list users with less than 10 skills.

TIA

[Dr Atul G- LNG]

Hi @CV1 

Create a report on the User table. Then, use the related list sys_user_has_skill to retrieve the count.

I do not currently have the skill set set up, but you can generate the report in this way

or use:

Use Database View (Recommended for Accurate Count)

1. Create a Database View joining:

   • sys_user

   • sys_user_has_skill

2. Join condition:

   • sys_user.sys_id = sys_user_has_skill.user

3. Create a report on this Database View.

4. Use:

   • Group by → User

   • Aggregation → Count

5. This will show the number of skills per user.