Counting # of projects someone worked on, not tasks in those projects

Forum|Forum|2 years ago
June 14, 2023
3 replies
1610 views

I feel like I'm missing something here, but the ask:

We have a design team that wants to know how many individual projects they've had tasks on. I can use a Task report and group by project, but it does seem to require additional export/filtering to get what I am after. These teams could have 1-4 tasks per project.

The ultimate result would be something like this:

Total Projects Worked on in 4Q22

John Doe 25

Jane Doe 45

Jamie Doe 65

etc

thanks in advance!

Workfront

This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.

Best answer by RandyRoberts

Could you do a project report and filter by project users?

TIP: if this solved your problem, I invite you to consider marking it as a Correct Answer to help others who might also find it of use.

RandyRoberts

Accepted solution

Community Advisor

Could you do a project report and filter by project users?

TIP: if this solved your problem, I invite you to consider marking it as a Correct Answer to help others who might also find it of use.

Doug_Den_Hoed_AtAppStore

Community Advisor

Hi @ryan_mcgee,

In addition to the tip from @randyroberts, I invite you to consider deploying this User Project Count solution (as below) which shows the number of Projects per User in grid mode, and the number of Assignments per User in Chart mode.

Regards,

Doug

skyehansen

Doug, you also came up with a solution that was an assignment report as a matrix report. Unfortunately all the links are dead and info is dated... if you'd care to reproduce the contents of this post again, I'm sure it would be appreciated by the community.

https://experienceleaguecommunities.adobe.com/t5/workfront-questions/project-report-by-assignments/m-p/489580

(hint, it involved a DCNT on one of the columns, and then a matrix grouping by project name and assigned to name)

KellieGardner

Community Advisor

Agree with Randy. You can filter a project report by "project users". The tricky part is the grouping to get it to count the number of unique projects to display the way you want.