Reporting on Projects by Task Assignee

Question

Hello! I am trying to pull a list of all projects where any of a certain group of assignees have a task. I can pull total tasks by assignee and total projects by assignee but that doesn't get me what I need. They don't own the project, but have tasks within them. Their manager is trying to get a list of all the projects their team was involved in for 2025. I'm good with a report, dashboard widget or analytics board widget, just don't know how to tell Wrike that is the data I want.

Eric Fiero · Answer

In Analyze I imagine there is a formula where you could get this information but I am not sure exactly how to build out the pivot table to test. Like a "CountIF" function?

Pietro Poli · Answer

Hi @Katherine Johnson you can't do it by dashboard.

I've checked if I can add as metrics something like MIN number of task but that options is not available.

😫

Katherine Johnson · Answer

Thank you @Pietro Poli - The table gave me a list of projects and number of tasks in each project and that is almost perfect, but can I get a total number of projects besides manually counting the rows?