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

Question

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 · Answer

@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.

Sign up

Login with SSO

Login to the community

Login with SSO

Scanning file for viruses.

This file cannot be downloaded