Aggregate Planned Hours Remaining for Task Assignees

[MikeMcGovernC1]

We have a team that is managing their capacity in Jira and focus on "hours remaining" on Jira cards assigned to their team members. The lower the "hours remaining" for an individual in Jira, the more likely they'll be assigned to incoming work as they are the most available.

We are exploring a transition from Jira to Workfront for this team, but replicating this reporting and capacity management style is a "must have" requirement.

Two questions:

1) Does anyone have any recommendations on replicating this reporting in Workfront?

2) Any thoughts on how to reframe existing Workfront reporting to meet this team's needs?

[AbiBeggs]

Hi! I've added a screenshot of a similar report we use for this below. We filter it by:

Assigned To Manager ID In $$USER.ID

and Number of Children Equal (Case Sensitive) 0

and Planned Completion Date Between $$TODAYbw and $$TODAYew+1w

and Project Status Equates With In CUR

and Status Not In , Complete

and Work Greater Than 0H

Let me know if this is helpful or if you have any questions.

[MikeMcGovernC1]

Thank you! Is this a task report?

[AbiBeggs]

Yes! Sorry that would've been helpful info to include, it's a task report. also adding the screenshots for our chart groupings - let me know if any additional info would be helpful.

[MikeMcGovernC1]

Thanks! Are you able to use a matrix report instead of a chart for this?

[AbiBeggs]

Yeah, you could definitely adjust this to be a matrix report instead of a chart if that works best! That same info in a matrix report could look similar to this