Your achievements

Level 1

0% to

Level 2

Tip /
Sign in

Sign in to Community

to gain points, level up, and earn exciting badges like the new
Bedrock Mission!

Learn more

View all

Sign in to view all badges

Adobe Summit is happening now. Discover what's next in customer experience.

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

Avatar

Level 1

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

2 Replies

Avatar

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

Avatar

Level 5

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_0-1677775362711.png