How to remove duplicate project names in an Assignment Report?

Question

Hi everyone! i am working on an Assignment report for a project team so they can see all the completed projects they were assigned to. This report is based on the $$User so it'll be a custom view for whomever opens the report. If a user was assigned to multiple tasks in a project it will show up multiple times on this report, and they don't want to see the task name they just care about seeing which project name they worked on. Is there a way to remove these duplicate items on the report or should I utilize a different report for this request? As always, thank you all!

skyehansen · Accepted Answer

You can create a project report, and filter for the project status you want (completed project statuses). Then switch over to text mode and copy / paste in Jon Chen's code from the "Record Count of Projects" section.

https://experienceleaguecommunities.adobe.com/t5/workfront-blogs/common-reporting-challenges/ba-p/518300

KellieGardner · Answer

You can group an assignment report by the project name and then have the default page be the "summary" page. Then it should jus show a count of how many assignments they had in said project.

Only caveat is that the project name won't be clickable from the summary page if that's a need.

Sign up

Login with SSO

Login to the community

Login with SSO

Scanning file for viruses.

This file cannot be downloaded