Task Report - Planned Hours are only reflecting 1 assignment, not all | Community
Skip to main content
M
majpjr
November 30, 2022
Solved

Task Report - Planned Hours are only reflecting 1 assignment, not all

  • November 30, 2022
  • 1 reply
  • 781 views

Hello,


The issue is - in the task report we built it's pulling ALL the hours assigned on a task to the primary assignee. So, if you have 4 people with 25 hours a piece, all 100 of those hours are only pulling into the report on the primary person rather than 25 hours/person.

 

The WLB and Planner all reflect 25 hours per person, correctly.

 

The Task report is pulling 100 hours on just 1 person.

 

Help!

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

If I'm reading your post correctly, I think this is normal. You sound like you're running a task report and grouping by primary assignee (a.k.a. "assigned to") which makes it look like the total planned hours all belongs to one person

If that's the case, you should probably switch to using an assignment report instead. You can continue to group by assigned to (it's used differently for assignment reports) but if a task is assigned to four people, it will show up as four different line items, each with one person, and all should have planned hours as you had allocated.

1 reply

skyehansen
Community Advisor
skyehansenCommunity AdvisorAccepted solution
December 1, 2022

If I'm reading your post correctly, I think this is normal. You sound like you're running a task report and grouping by primary assignee (a.k.a. "assigned to") which makes it look like the total planned hours all belongs to one person

If that's the case, you should probably switch to using an assignment report instead. You can continue to group by assigned to (it's used differently for assignment reports) but if a task is assigned to four people, it will show up as four different line items, each with one person, and all should have planned hours as you had allocated.

    M
    majpjrAuthor
    December 1, 2022

    Thanks. Yes, you are reading that correctly. I am using a task report.

    Ok, let me try that one. I still don't understand why WF built it's reporting structure like this and what the purpose of making this so complicated.

    skyehansen
    Community Advisor
    skyehansenCommunity Advisor
    December 1, 2022

    if you have the experience, you should consider it like a relational database. The object you are reporting on, the task, has a "collection" of assignments (multiple assignments available per task). There's no way to engage this sort of reporting on the object report you chose to use (task report).

     

    By needing to report on each separate assignment, you have a number of different options.

     

    Option 1: You could have used a collections column such as what's found here

    https://experienceleague.adobe.com/docs/workfront/using/reporting/reports/text-mode/reference-collections-report.html?lang=en

     

    Option 2: Assignment report (easier and allows you to group by assignee)

     

    I hope I don't come across as supporting Workfront's choices, as I really don't have enough technical expertise to say one way or the other!! This is just my understanding of, and way around, how the reporting functionality works.

     

    Good luck!

      Terms & ConditionsAccessibility statement

      Loading footer...