Task report splitting out planned hours by assignee | Community
Skip to main content
N
NickVa7
Level 9
July 10, 2023
Solved

Task report splitting out planned hours by assignee

  • July 10, 2023
  • 1 reply
  • 2195 views

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.
Best answer by skyehansen

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

1 reply

skyehansen
Community Advisor
skyehansenCommunity AdvisorAccepted solution
Community Advisor
July 10, 2023

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

    N
    NickVa7Author
    Level 9
    July 11, 2023

    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.

    M
    MoSuleiman
    July 30, 2023

    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

    Terms & ConditionsAccessibility statement

    Loading footer...