I'm trying to think of a way to filter a report to see a specific set of users planned hours. Here is my problem statement:
If User A is on project X show me ALL their planned hours for any project.
Anyone know if this is possible. I'm hitting roadblocks and can't think of a way to do this.
There are different ways to arrive at this. This approach uses an Assignments report. This report can include a Planned Hours column that can be summed/grouped by User.
The below filter in an Assignments report will return a list of user assignments (tasks or issues) where the task or issue:
That does mean you have to hard code the project ID of Project X in the filter's text mode.
EXISTS:a:$$EXISTSMOD=EXISTS
EXISTS:a:$$OBJCODE=PRTU
EXISTS:a:projectID=project_X_ID_here
EXISTS:a:userID=FIELD:assignedToID
task:status=INP NEW
task:status_Mod=in
workRequired=0
workRequired_Mod=gt
OR:1:EXISTS:b:$$EXISTSMOD=EXISTS
OR:1:EXISTS:b:$$OBJCODE=PRTU
OR:1:EXISTS:b:projectID=project_X_ID_here
OR:1:EXISTS:b:userID=FIELD:assignedToID
OR:1:opTask:statusEquatesWith=INP NEW
OR:1:opTask:statusEquatesWith_Mod=in
OR:1:workRequired=0
OR:1:workRequired_Mod=gt
Hope that helps.
-WE
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
