


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.
Views
Replies
Sign in to like this content
Total Likes
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
Views
Replies
Sign in to like this content
Total Likes
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
Views
Replies
Sign in to like this content
Total Likes
This is great! Thank you so much.
Views
Replies
Sign in to like this content
Total Likes