Planned hours and actual hours per assignee when multiple assignees per task | Community
Skip to main content
N
NickVa7
Level 9
December 10, 2024
Question

Planned hours and actual hours per assignee when multiple assignees per task

  • December 10, 2024
  • 3 replies
  • 1021 views

Hey WF Community,


Has anyone cracked the code on generating a report that shows planned hours and actual, by assignee, for any given calendar date range, when there are many assignees on a given task?  That last part is the kicker.  If we only had one assignee per task I could generate this report.

 

I've received this request from users many times over the years and I'm yet to find a reporting solution within WF that can accommodate this.

 

Thanks,

Nick

3 replies

A
AmyReilly
Level 4
December 10, 2024

Could you share how you generate the report when you have only one assignee?  That would be helpful for us.

N
NickVa7Author
Level 9
December 10, 2024

Hi @amyreilly  - see attached screenshots.  You would be using an Hours report.
Cheers!

 

A
AmyReilly
Level 4
December 10, 2024

Thank you!  We are still trying to find out how to divide out the planned hours by day, so this isn't quite what we're looking for.  (For now, we're doing it in Power BI, but would love to do it in Workfront.)

    skyehansen
    Community Advisor
    skyehansenCommunity Advisor
    December 10, 2024

    I don't think this can be done, but you can probably get close using the same hours report. Your kicker is that currently the hours report is only storing the task (or issue) planned hours. Anything else would involve calling the collection on the task assignments. I'll only give a sample here -- it would look something like this:

    displayname=Column Name listdelimiter=<p> listmethod=nested(task.assignments).lists type=iterate valueexpression=CONCAT({workRequired},' - ',{assignedTo}.{name}) valueformat=HTML

     

    As you can see, I am calling the collection of assignments off the task object in your hours report. If you had enough familiarity with valueexpressions (and collections), you could maybe drill down further (reminder: your valueexpression statement is performing calculations in the Assignment object, so look in Assignment for the workRequired and assignedTo fields).

     

    If you don't have the familiarity or if your needs are too specific, this sample would at least give you the breakdown of all assignments.

      N
      NickVa7Author
      Level 9
      December 12, 2024

      Thanks for the suggestion, Skye.

      Unfortunately, I need to sort, group, aggregate and chart on the Assignment object's Planned Hours.  We'll likely try and solve for this by pushing the data to external databases and BI tools with more flexibility.

      kautuk_sahni
      Community Manager
      kautuk_sahniCommunity Manager
      Community Manager
      September 1, 2025

      @nickva7 just checking in! Were you able to get this resolved? If one of the replies above helped—whether it completely solved the issue or simply pointed you in the right direction—marking it as accepted can make it much easier for others with the same question to find a solution. And if you found a different way to fix it, sharing your approach would be a great contribution to the community. Your follow-up not only helps close the loop but also ensures others benefit from your experience. Thanks so much for being part of the conversation!

      Kautuk Sahni
      Terms & ConditionsAccessibility statement

      Loading footer...