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

[JenniferLegate]

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? 

[Ross_Barton]

@JenniferLegate Any luck with this? I remember wanting to do something similiar and discovered that the workPerDate field (an Assignment object) is what I was after. It's the field Workload Balanncer uses to show daily load. However, it's only exposed in the API and not available in native reporting.

[JenniferLegate]

Thanks, Ross. I was hoping for a native Workfront reporting option, but this could work if I can find developers to pull that field. I appreciate you sharing it. I’m afraid the Workload Balancer may be the only native way to view the data this team needs.

[Doug_Den_Hoed__AtAppStore]

Hi @JenniferLegate and @Ross_Barton,

From working with it non-natively (via the API), I can assert that workPerDay is indeed what you'd need, but to my knowledge is not available through the native UI.

Regards,

Doug