Skip to main content
Level 9
Jul 10, 2023 9:24 PM UTC
Solved

Task report splitting out planned hours by assignee

Hi WF Community,

Does anyone know if it's possible to split out a task report by user and planned hours, or would an assignment or work item report be the only options for that?

Example:

- 20 planned hours on Task A

- Pardeep is assigned 5 planned hours

- Keleel is assigned 15 planned hours

 

We would like to see the task report grouped by task, and then see the breakout of planned hours by assignee under the task.

I know this can be handled in an assignment report, but curious if a task report can do this as well?
Thanks,
Nick

This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.
skyehansen
skyehansenAccepted solution
Jul 10, 2023 10:40 PM UTC

hi Nick, I'm not sure if you're familiar with collections in reporting, but if you are, your question is an example of where they would be used. 

https://experienceleague.adobe.com/docs/workfront/using/reporting/reports/text-mode/reference-collections-report.html?lang=en#reference-a-collection-in-the-view-of-a-report

 

You're specifically looking for the assignments collection and then Planned Hours is known as workRequired in the system. A quick search focusing on collections, assignments and workrequired would definitely net you with some good samples to start experimenting with.

https://experienceleaguecommunities.adobe.com/t5/custom/page/page-id/GlobalSearch#q=collections%20report&sort=relevancy&f:el_product=[Workfront]

 

Here's a very specific answer with that in mind: https://experienceleaguecommunities.adobe.com/t5/workfront-questions/text-code-for-assignement-breakdown/m-p/480987#M13783

9 replies

skyehansen
Adobe Champion and Community Advisor
skyehansenAdobe Champion and Community AdvisorAccepted solution
Jul 10, 2023 10:40 PM UTC

hi Nick, I'm not sure if you're familiar with collections in reporting, but if you are, your question is an example of where they would be used. 

https://experienceleague.adobe.com/docs/workfront/using/reporting/reports/text-mode/reference-collections-report.html?lang=en#reference-a-collection-in-the-view-of-a-report

 

You're specifically looking for the assignments collection and then Planned Hours is known as workRequired in the system. A quick search focusing on collections, assignments and workrequired would definitely net you with some good samples to start experimenting with.

https://experienceleaguecommunities.adobe.com/t5/custom/page/page-id/GlobalSearch#q=collections%20report&sort=relevancy&f:el_product=[Workfront]

 

Here's a very specific answer with that in mind: https://experienceleaguecommunities.adobe.com/t5/workfront-questions/text-code-for-assignement-breakdown/m-p/480987#M13783

Translate
NickVa7Author
Level 9
Jul 11, 2023 4:28 PM UTC

Thanks for nudging me in that direction, Skye.  A collection could work, I'll see if it suffices based on requirements.  I was able to list assignees and their planned hours in a custom column.

Translate
New Member
Jul 30, 2023 9:36 PM UTC

Hi @nickva7 were you able to find a solution? Keen to know as I'm trying to build a report to compare planned hours vs actual hours by job role/user. So far it seems I need to use an assignment report but this comes with some issues so was wondering if I could use a task report as well. 

 

Thanks

 

Mo

Translate