Which report is best for % values of scheduled hours for each individual role in a department? | Community
Skip to main content
Kundanism
Kundanism
Level 10
March 11, 2024
Question

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

  • March 11, 2024
  • 1 reply
  • 957 views

Hi

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

Any suggestions?

Mvh

Kundan.

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

1 reply

Daniel_Clarke
Community Advisor
Daniel_ClarkeCommunity Advisor
Community Advisor
March 11, 2024

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?)

    Kundanism
    KundanismAuthor
    Level 10
    March 12, 2024

    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.

     

     

    Daniel_Clarke
    Community Advisor
    Daniel_ClarkeCommunity Advisor
    Community Advisor
    March 12, 2024

    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. 

      Terms & ConditionsAccessibility statement

      Loading footer...