Which report is best for % values of scheduled hours for each individual role in a department?

7 replies
996 views
Translate All

Hi

Any suggestions?

Mvh

Kundan.

Workfront

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

Daniel_Clarke

Adobe Champion and Community Advisor

Hey @kundanism -

I would tackle this with a task report based on planned hours. You could then show it as a pie chart per role for % or show as a column chart with an extra grouping to show the "stacked to 100" option to show percent.

Happy to provide more ideas / details if that didn't quite hit the mark! (ie, % of type of hour? % of each person's time in role total?)

Translate

KundanismAuthor

Level 10

Thanks @daniel_clarke

I followed the same, however not found as "Role Name", under grouping. Please refer it shows only in "Role ID".

How to resolve this "Role ID" to Role name?

Any idea or recommendation from your side.

Thanks is advance.

Mvh

Kundan.

Translate

Daniel_Clarke

Adobe Champion and Community Advisor

The typical text mode "change ID to :name" trick did not work here for me. Maybe another text mode expert could chime in!

If these tasks are consistently assigned to a role, you could add a task form to the template tasks and create a custom field "Role Name" that you could then use to pull into this report as a workaround.

Translate

Sign up

Login with SSO

Login to the community

Login with SSO