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

[pk____]

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

[Madalyn_Destafney]

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 : )

[KellieGardner · Accepted solution]

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

[KellieGardner]

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

[pk____]

Yes, your solution work and we were able to create report thank you.

[rossja08]

Hey Kellie,

Is there a way to edit actual hours within the report? 

I've seen the ability to edit planned hours but actual hours doesn't default as editable.

[KellieGardner]

You can not edit actual hours from this report as the field is a text mode field. I don't believe you can edit any of the line items from an assignment report.

[rossja08]

Thanks, I think it was in a task report where I was able to change planned, but not actual. I found it odd that they would be two different types of fields.

[KellieGardner]

Actual hours is a calculated field at the system level. Since time gets logged in hours by day this field is calculated on the back end to provide a total output which is why it's not an editable field in a report.