Surface actual hours per assignee on an Assignment report | Community
Skip to main content
N
NickVa7
Level 9
July 11, 2023
Question

Surface actual hours per assignee on an Assignment report

  • July 11, 2023
  • 2 replies
  • 1152 views

Hi WF Community,

 

I have a report that displays tasks with their multiple assignees below them.  Basically grouped by task.
Does anyone know of a way to show actual hours per assignee?  
I'm looking at text mode, and possibly the use of references, but I'm having a hard time getting to actual hours.

Thanks!
Nick

    This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.

    2 replies

    Madalyn_Destafney
    Community Advisor
    Madalyn_DestafneyCommunity Advisor
    Community Advisor
    July 13, 2023

    Hi there, I recommend creating an hour report instead. You can filter in the people/timeframe you want to pull, and still group by task name, then by hour owner name if you want, and add a column for actual hours. This will show you all time logged to the tasks by the person. You can also summarize the groupings to show the total hours by task by person in the groupings without expanding the grouping.

    If this helped you, please mark correct to help others : )
    N
    NickVa7Author
    Level 9
    July 13, 2023

    Thanks, Madalyn.  You are correct, that could work.  The challenge an hours report is that I get a lot of extra rows of data based on all of the hour entry records.  

    Madalyn_Destafney
    Community Advisor
    Madalyn_DestafneyCommunity Advisor
    Community Advisor
    July 14, 2023

    Yes, but that's where grouping by user/hour owner is handy. If you add a grouping for hour owner and sum the groupings, then you can see the total hrs per person on each task without having to expand the groupings. Essentially the groupings become your rows. Like this, it just shows first 2 columns of the report - grouped by task then hour owner:

     



    If this helped you, please mark correct to help others : )
    J_Mas
    J_Mas
    Level 5
    August 16, 2023

    I have this same issue (and I imagine others do as well). I'd love to have both planned hours and actual hours for an assignee on one report, but it seems like I can't do this.

    If I build an assignee report, I can get the planned hours, but not the actual (logged) hours for the person.

    If I build an hours report, I can get the logged hours, but I won't see planned hours for tasks that don't yet have logged hours.

    N
    NickVa7Author
    Level 9
    August 16, 2023

    Hi J_Mas - you can see some of my workarounds here if you desire.
    Cheers!

    Terms & ConditionsAccessibility statement

    Loading footer...