Creating a metric definition based on tasks created by members o the assignment group

[Dharaneetharan]

I have a requirement to report based on tasks created by a particular group members.I am thinking to creating a metric definition.

Can you anyone have an idea on this

[Ahmmed Ali]

Hello @Dharaneetharan 

I did not try it, but you can create a database view between your task table and sys_user_grmember table with query as task's opened_by IS group membership user. This will show all the existing records as well, may not show historically data accurately as when user is removed from group that data cannot be reported.

The metric definition solution also sounds good.

Thanks,

Ali