Hi Workfront Community,
For my ticket management project, I am trying to create a report for Team Leads that shows planned vs actual hours split my month for each assignee in the team.
This is how it looks like for now for a single assignee:
Now, if I add more assignees to this, this will look completely messes up.
Is there a way I can simplify this for all assignees at one place? Or a way I can give a dropdown of assignees to the TL where from they can choose and view the chart for each one by one?
Hi there! I agree, if you add more people to this it's not ideal for a chart, unless you could try the stacked column chart option to see how that looks first:
If that's still too busy, you can either:
- Have the report default to the Details view instead, with a collapsed grouping by person.
- Leave your chart how you have it and create a report prompt that prompts the TL to choose which team member they want to see, then the report runs only showing that person. I think that's the best route to go.
I also forgot to mention, @Varnikajaiswal - have you looked into the resource management tools in WF (Workload Balancer, Planner)? Other native ways you can show planned vs actual hours by team, role, user, etc.
Hi @Madalyn_Destafney ,
The prompt options does the job. But its still tedious process because we have many users working under a TL and selecting one by one for each take lots of time.
let me try 'resource management tools in WF (Workload Balancer, Planner)'
I would throw one more idea if visual aspect is not essential - matrix report could something like that:
although you most likely want montly groupings in column
Hope this helps