How create a simple report from actual hours vs planned hours for users | Community
Skip to main content
P
pk____
March 2, 2023
Solved

How create a simple report from actual hours vs planned hours for users

  • March 2, 2023
  • 3 replies
  • 4040 views

Hi WF community,
I have been trying to create a report by team/individual showing the amount of hours worked vs the ones planned. Can anyone guide me with that, I tried using the hours report but didn't get the desired output.

Thanks,

Pk

    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 KellieGardner

    What is the desired output you are looking for? 

     

    I like to use assignment reports so it breaks down to planned hours by user vs by task. To get the actual hours I use text mode with the following code:

     

    aggregator.displayformat=minutesAsHoursString
    aggregator.function=SUM
    aggregator.namekey=Actual Hours
    aggregator.valuefield=actualWorkCompleted
    aggregator.valueformat=compound
    displayname=Actual Hours
    linkedname=direct
    namekey=actualWorkCompleted
    querysort=actualWorkCompleted
    task=actualWork_Mod=gt
    textmode=true
    valuefield=actualWorkCompleted
    valueformat=compound
    viewalias=actualWorkCompleted

     

     

    3 replies

    Madalyn_Destafney
    Community Advisor
    Madalyn_DestafneyCommunity Advisor
    Community Advisor
    March 2, 2023

    Hi there! You can do this with a simple Hour report.

    Create a new Hour report, and you can add columns that pull the project planned vs actual (logged) hours or the planned vs actual hours for any object (project, task, issue, etc.). Actual hours is logged hours. 

    Then you can add a Grouping to your report to have it by 'hour owner' which is the person that logged the hours (or can do by hour owner home team name if you're looking to do by team.

    If you found this useful, please mark this solution correct to help others : )

    If this helped you, please mark correct to help others : )
      KellieGardner
      Community Advisor
      KellieGardnerCommunity AdvisorAccepted solution
      Community Advisor
      March 2, 2023

      What is the desired output you are looking for? 

       

      I like to use assignment reports so it breaks down to planned hours by user vs by task. To get the actual hours I use text mode with the following code:

       

      aggregator.displayformat=minutesAsHoursString
      aggregator.function=SUM
      aggregator.namekey=Actual Hours
      aggregator.valuefield=actualWorkCompleted
      aggregator.valueformat=compound
      displayname=Actual Hours
      linkedname=direct
      namekey=actualWorkCompleted
      querysort=actualWorkCompleted
      task=actualWork_Mod=gt
      textmode=true
      valuefield=actualWorkCompleted
      valueformat=compound
      viewalias=actualWorkCompleted

       

       

        S
        sochorj
        September 29, 2023

        Hi, this worked for me as well. However, I would also like to have this field be a field that is available to display in a Chart. For some reason this Actual Hours column/field does not display in the selection and there is not a text mode option to add/view the code.

        Any ideas on this?

        Madalyn_Destafney
        Community Advisor
        Madalyn_DestafneyCommunity Advisor
        Community Advisor
        October 2, 2023

        You have to apply a grouping in a report before you can have that option in its chart. Chart options in a report are driven from the groupings you apply first. 

        If this helped you, please mark correct to help others : )
        KellieGardner
        Community Advisor
        KellieGardnerCommunity Advisor
        Community Advisor
        March 29, 2023

        @pk____  did any of these solutions work for you or do you still need a solution?

        T
        TerriStry
        August 21, 2023

        Hi Kellie, your assignment report with the Actual Hours text mode code worked out great for my needs -- we are auditing our planned hours and durations in templates.  So happy Workfront keeps these up for an extended time.  I have one question, is there a way to get the Planned Hours to calculate and roll up to the grouping level, similar to the Actual Hours on the screen grab shown above?  Thank you!

        KellieGardner
        Community Advisor
        KellieGardnerCommunity Advisor
        Community Advisor
        August 21, 2023

        @terristry - you should be able to accomplish this natively in the reporting area. If you select the column, there should an option to sum it.

         

         

        Terms & ConditionsAccessibility statement

        Loading footer...