Post

2 followers Follow
0
Avatar

Report on common task name across multiple project

I'm wondering if anybody knows how to generate a report that would show me actual effort reported for a task across multiple projects?

For example, if I had 20 projects and they all contained a task called "eat lunch" but my 12 people assigned across the 20 projects spent different amounts of time, can I have a report generate the statistic of who, when, and actual effort?

Thanks

 

Sean Matthews Answered

Please sign in to leave a comment.

2 comments

2
Avatar

Sean,

If you are looking at actual effort, then you will be running your report looking at timesheet data.  You can know who reported time using the reported by field and again the time will be booked against a task (eat lunch in your example) if you also bring in the 'parent project' for the task then you will be able to differentiate between which project each person has booked against.

If you are using the actual effort field from the task data, then the parent project field would work there also.

Hope that helps, we have exactly the same situation, where our standard template is full of tasks that are now appearing dozens of times across the portfolio.

Phil

Phil Smith 2 votes
Comment actions Permalink
0
Avatar

Thanks very much Phil, worked out perfectly!

Cheers,

Sean

 

Sean Matthews 0 votes
Comment actions Permalink