Expand my Community achievements bar.

Don’t miss the Workfront AMA: System Smarts & Strategic Starts! Ask your questions about keeping Workfront running smoothly, planning enhancements, reporting, or adoption, and get practical insights from Adobe experts.

Report Help Needed - populate a list of users who have planned hours on a day exceeding 7 hours

Avatar

Level 2

Hello all,

 

I've posed this question to Adobe Support, but their solution isn't quite working. So I thought I'd try all you brilliant people in the community!

 

I have a team that is trying to solve a resource allocation issue via reporting, as manually checking workload balancer every hour is not sustainable.

 

They would like a report that will populate any users who have hours on a given day exceeding 7 hours. Note, this is not actual hours, as this team is not tracking time. They want to see who is over-allocated on planned hours on any given day (can be within a timeframe of $$TODAY to $$TODAY+8w, as an example).

 

I've found solutions ranging from an Hours report, to an Assignment report, to a Budgeted Hours report (AI gave me that last one, which I'm raising an eyebrow at). I believe I need an Assignment report, but having trouble narrowing the groupings down to the day / planned hours for a user. 

 

Any thoughts? 

0 Replies