De-duplicate a job role report

[Niko_Ahlgren]

Hello. 

I am making a report that needs to list how many of each job role is attached to a project.

The problem is that one project can have multiple tasks assigned to the same person that has a job role. So is there any way to count unique job roles per project? 

[SuryaLakhani · Accepted solution]

Hi Niko,

If you are looking for a count, I'd say use an assignment report, group by project, then group by job role. You should be able to see the count in Matrix view. 

If you want to list them, you can use a collection of Project Users in a Project report:

• Field Name: projectUsers
• Attribute Type ObjCode: PRTU
• Field Type: ProjectUser
• URL: https://api-cl01.my.workfront.com/attask/api/v19.0/prtu/metadata

[Niko_Ahlgren]

Thank you for this tip. Unfortunately the matrix shows all the same duplication. One person with a job role assigned to multiple tasks within one project. I'll keep looking how to get it so that it shows each job role only once if that job role has been assigned a task.

[kautuk_sahni]

@Niko_Ahlgren Just checking in — were you able to resolve your issue? We’d love to hear how things worked out. If the suggestions above helped, marking a response as correct can guide others with similar questions. And if you found another solution, feel free to share it — your insights could really benefit the community. Thanks again for being part of the conversation!