Report: Planned hours + Templates + Job roles | Community
Skip to main content
January 22, 2025
Solved

Report: Planned hours + Templates + Job roles

  • January 22, 2025
  • 1 reply
  • 426 views

Hi,
Would it be possible to create a report that:

1.Shows the total planned hours per job role, grouped by project templates?

Or

2. A project template report that displays the total planned hours, grouped by job roles or task assignments?

We are trying to determine a way to calculate the total planned hours allocated to each role within the project templates. These project templates are part of a specific portfolio.

This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.
Best answer by KellieGardner

If you are assigning 1 user/job role to each task then you could accomplish this with a template task report, sum your planned hours columns and group by job role and template name. 

 

 

 

If you are assigning multiple users/job roles to task then you would need to get creative with this because task reports will only pull in the primary assignee details. You could create projects from the templates and then create an assignment report (this will get the details of all assignments on the tasks) filter for your specific test projects, group it by the test project name and job role and make sure you sum the planned hours column. 

1 reply

KellieGardner
Community Advisor
KellieGardnerCommunity AdvisorAccepted solution
Community Advisor
January 31, 2025

If you are assigning 1 user/job role to each task then you could accomplish this with a template task report, sum your planned hours columns and group by job role and template name. 

 

 

 

If you are assigning multiple users/job roles to task then you would need to get creative with this because task reports will only pull in the primary assignee details. You could create projects from the templates and then create an assignment report (this will get the details of all assignments on the tasks) filter for your specific test projects, group it by the test project name and job role and make sure you sum the planned hours column.