Custom Interactive filter to display managers

[CV1]

Hello Everyone,

Looking for help on how to address the following requirement.

Creating an Interactive filter that lists all managers.

On selecting the manager , a report to display all employees reporting to the manager and their skills.

This will be on a dashboard.

TIA

[AndersBGS]

Hi @CV1 ,

 what issue occur according to the requirement? According to your description it should be fairly easy from the users table.

[CV1]

Hi @AndersBGS ,

We have a group called "Managers" where the group members contains the list of managers.

Following are the steps I followed:

1. Created database view for groups (sys_user,sys_user_grmember,sys_user_group)
2. Created interactive filter using above view.This displays managers.
3. I need to add interactive filter reference. For this I created a new database view > User skill  joining, sys_user,sys_user_has_skill.
4. When trying to add the "user Skill" view to the filter, I am getting error. could be i am not using the correct field.

I am attaching a screen capture for reference.

My goal is to list all managers in the interactive filter. On selecting a manager the report should list all the employees reporting to that manager and show the skills they have.

TIA