Skip to main content
Kundanism
Level 10
Mar 29, 2023 12:48 PM UTC
Question

Report for Planned vs Actual Hours MONTHLY for user in Chart / Table? ???

Hello to all community members;

 

Any one has experience to create report for Planned vs Actual Hours for User / assginments in Chart / matrix?

Which report type works best... looking for recommendation / text code....

 

Best regards,

This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.

3 replies

KellieGardner
Community Advisor
Community Advisor
Mar 29, 2023 4:09 PM UTC

Have you tried using Planner to see the data you need? Not sure if this would work for your needs. 

I also use a report that pulls in planned and actual hours into an assignment report using text mode so it can't be shown in a matrix or chart view but the summary view gives a decent look to it. Grouped by user and project. 

 

 

Text Mode for Actual Hours:

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
shortview=false stretch=100
textmode=true
valuefield=actualWorkCompleted
valueformat=compound
viewalias=actualWorkCompleted
width=100

 

Text Mode for Planned Hours:

aggregator.displayformat=minutesAsHoursString
aggregator.function=SUM
aggregator.namekey=workRequired
aggregator.valuefield=workRequired
aggregator.valueformat=compound
linkedname=direct
namekey=workRequired
querysort=workRequired
textmode=false
valuefield=workRequired
valueformat=compound
viewalias=workrequired

Translate
Level 4
Sep 18, 2024 11:52 PM UTC

Thank you for the textmode.  Which field are you using to get the "month" breakout in the assignment report? 

Translate
KellieGardner
Community Advisor
Community Advisor
Sep 19, 2024 4:14 PM UTC

mine is grouped off of planned completion date.

Translate