Forum Discussion
Group by assigned resources
Is it possible to create a Gantt view that is grouped by individual resources where tasks are repeated if assigned to multiple resources? I don't want a group containing multiple resources, I want a Gantt chart with one group for each resource, even duplicating tasks if necessary.
What I've found so far is that this is not possible, but I can create a Gantt chart with a view for each resource. Is there a way to print all of these individual resource Gantt views on one report?
Finally, when I have multiple resources, one resource often completes its work mid-task. Is there a way to filter tasks that may have remaining work, but the remaining work for the specific resource is zero?
Again, you won't be able to show a Gantt for just one resource if multiple resources are assigned to each task, unless there is a measurable split in the task such that only one resource works on the task for the first split part and another resource only works on the task for a second split part. In that case you could filter by resource and date range. But, I'm not sure what that really gains for the amount of work necessary to get those multiple "resource-Gantt" views.
For the second part of your question, the answer is as stated above. Create a dual filter that isolates the resource name and a specific date range (i.e. whatever John is working on after December 1st).
John
You've already answered your first question. Since the Gantt Chart view is a task based view, resource assignments are not individually viewable, unless tasks with multiple resources are duplicated, one for each resource. But, that makes no sense.
The best way to look at individual resource assignments is via the Resource Usage view. Granted, it doesn't show a Gantt bar display but the relevant information about resource work and time periods are fully spelled out.
You say you figured out a way to display an individual Gantt for each resource, I'd like to see what you mean by that. It would certainly be possible is there is only one resource assigned to each task but if multiple resources are assigned to a given task, it doesn't make sense.
I don't quite understand what you mean by "print all of these individual resource Gantt views in one report". Perhaps a better understanding of your "individual Gantt view" will shed some light on possible ideas. For example, a compound filter that includes each individual Gantt view.
You last question is confusing. As written it doesn't seem to make sense (e.g. filter for non-zero remaining work but include zero work??). An example or a screen shot mock up might help to clarify.
John
John-project, thanks for the reply. sorry my question was so confusing. For the first part of my question, I think I may need to filter a report (view) just for one resource. That's what I mean by a Gantt for each resource. it's not all at the same time. Then run that same report over and over for each resource. I wish I could run all of those reports at one time, but I don't think that's possible without code.
Here is the second part of my question:
John stops work on a task in May. Jane starts back up on the task in November. In December I want to print a Gantt chart for John that no longer includes this task, because he is done, no work remaining for him.
Again, you won't be able to show a Gantt for just one resource if multiple resources are assigned to each task, unless there is a measurable split in the task such that only one resource works on the task for the first split part and another resource only works on the task for a second split part. In that case you could filter by resource and date range. But, I'm not sure what that really gains for the amount of work necessary to get those multiple "resource-Gantt" views.
For the second part of your question, the answer is as stated above. Create a dual filter that isolates the resource name and a specific date range (i.e. whatever John is working on after December 1st).
John
