Workfront

meshackOm · 10/18/23

Hi Community,

I wants to create a report to capture resources over allocation hours. Any help on how to create this including which filter to apply would deeply appreciated.

Thanks

Mesh

VictoriaLinn · 10/19/23

Hi @meshackOm - Depending on how your projects are setup with hours / durations, reports aren't always the best way to go to show over allocation of hours. Instead, the Resource Management tools (Planner / Workload Balancer) are better ways to show this information. There are ways to get links to share with leadership teams that might not always go into Workfront.

The reason for this, reports in Workfront, if you have 10 Planned Hours over 2 Days (Duration) the report will only show the (10) hours on one date (Planned Start Date/Completion Date, depending how you set it up) - Workload Balancer however spreads the hours across two days into 5 hours for each day. So, as you can see, the reports can cause some problems with showing users as overallocated incorrectly. But, if you're tasks are always one day in length, then you can go that route.

Just some food for thought on this!

View solution in original post

VictoriaLinn · 10/19/23

Hi @meshackOm - Depending on how your projects are setup with hours / durations, reports aren't always the best way to go to show over allocation of hours. Instead, the Resource Management tools (Planner / Workload Balancer) are better ways to show this information. There are ways to get links to share with leadership teams that might not always go into Workfront.

The reason for this, reports in Workfront, if you have 10 Planned Hours over 2 Days (Duration) the report will only show the (10) hours on one date (Planned Start Date/Completion Date, depending how you set it up) - Workload Balancer however spreads the hours across two days into 5 hours for each day. So, as you can see, the reports can cause some problems with showing users as overallocated incorrectly. But, if you're tasks are always one day in length, then you can go that route.

Just some food for thought on this!

meshackOm · 10/24/23

Hi @VictoriaLinn thank you so much for your input and suggestion. Which links can I share with leadership teams or managers so that they can easily see resources overallocation or under allocation?

Thanks

Mesh

VictoriaLinn · 10/25/23

On Planner, you can Export too, but both have a (very small) link option on the right that allows you to grab a shareable link. They could always go to the Resource Tools directly, but this has helped me in the past because it's less clicks.