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

Question

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

KellieGardner · Accepted Answer

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 · Answer

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

Sign up

Login with SSO

Login to the community

Login with SSO

Scanning file for viruses.

This file cannot be downloaded