Workfront

RyanMcGee · 6/14/23

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!

RandyRoberts · 6/14/23

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.

View solution in original post

RandyRoberts · 6/14/23

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 · 6/14/23

Hi @RyanMcGee,

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 · 6/14/23

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...

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

Doug_Den_Hoed__AtAppStore · 6/14/23

Yep: thanks @skyehansen; that very report is the one in the Package above that I mentioned.

Regards,

Doug

skyehansen · 6/14/23

sorry Doug, didn't read the image well enough

KellieGardner · 6/15/23

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.