Skip to main content
Level 3
giu 26, 2025 5:51 PM UTC
Risolto

Need to create a chart that shows how many projects a user has been on

I need to be able to create a chart that shows how many projects a user has been on. For example, how many jobs has a designer been on this year?

I have tried various text mode, assignment reports, task reports, project reports and can't get where I need to be.

A designer could have multiple assignments (tasks) on one project, but I can't find a way to essentially report the number of projects a designer was a "user" on.

 

Anyone solved this riddle? Thank you in advance!

Questo argomento è stato chiuso alle risposte.
CelSal01
CelSal01Risposta
Level 2
giu 27, 2025 5:06 PM UTC

I've done this by creating an Assignment report then:

  • Put a distinct count on the Project name field
aggregator.displayformat=val
aggregator.function=DCNT
aggregator.namekey=project:name
aggregator.valuefield=project:name
aggregator.valueformat=val
displayname=
linkedname=project
namekey=view.relatedcolumn
namekeyargkey.0=project
namekeyargkey.1=name
querysort=project:name
shortview=true
valuefield=project:name
valueformat=HTML
  • Group by "Assigned to: Name" and "Project: Name" 

Result:

 

9 risposte

Sven-iX
Community Advisor
Community Advisor
giu 26, 2025 7:37 PM UTC

Best I can come up with is this: Work Item report grouped by User, then Project

Sadly we can't report on ProjectUsers. A User has a "workItems" collection that point to projects but there's no way to get a list of unique projects out of it...
Hope this helps! 

 

Tradurre
ljorr16Autore
Level 3
giu 27, 2025 1:30 PM UTC

Great tip, I'll give that a go and see if it might work.

Tradurre
skyehansen
Adobe Champion and Community Advisor
giu 26, 2025 9:35 PM UTC

Workfront has an out of box "projects I'm on" filter, which gives you a clue. It consists of a combination of filters including project users ID, whether you own the project, are a sponsor, or if you created the project.

 

You can start by using a combination of any of these filters for your own report, but I would focus on the project users ID filter, and then layer in an exists statement to cover whether there are any assignments to that specific user. The reason for the added exists statement is because frequently users may end up as a project user but not be assigned to tasks or issues. This will remove those projects.

 

You can probably find examples of good exists filters as well, maybe do a search on the words "exists" and "assgn"

 

Tradurre
Sven-iX
Community Advisor
Community Advisor
giu 27, 2025 8:04 AM UTC

Right but how do I get to OP's ask of seeing a list of users and which projects they're actually on? 
I can do a project report filter out users without assignments. But I can't make it list users.
I can do a user report and filter out those that aren't project users

What am I missing? 

Tradurre
CelSal01
CelSal01Risposta
Level 2
giu 27, 2025 5:06 PM UTC

I've done this by creating an Assignment report then:

  • Put a distinct count on the Project name field
aggregator.displayformat=val
aggregator.function=DCNT
aggregator.namekey=project:name
aggregator.valuefield=project:name
aggregator.valueformat=val
displayname=
linkedname=project
namekey=view.relatedcolumn
namekeyargkey.0=project
namekeyargkey.1=name
querysort=project:name
shortview=true
valuefield=project:name
valueformat=HTML
  • Group by "Assigned to: Name" and "Project: Name" 

Result:

 

Tradurre
ljorr16Autore
Level 3
giu 27, 2025 5:25 PM UTC

This looks promising, thank you!

Tradurre