Respondido

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

Forum|Forum|2 years ago
March 2, 2023
3 respostas
4040 Visualizações

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

Workfront

Este tópico foi fechado para respostas.

Melhor resposta por 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

Madalyn_Destafney

Community Advisor

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

Resposta

Community Advisor

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

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

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

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

T

TerriStry

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!