Expand my Community achievements bar.

Do you have questions about the migration to Adobe Business Platform? Come join our upcoming coffee break and ask away!
SOLVED

Reporting Help

Avatar

Community Advisor

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. 

 




1 Accepted Solution

Avatar

Correct answer by
Community Advisor

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:

  • is in New or In Progress Status
  • has Planned Hours greater than 0
  • is assigned to anyone on the Project Team associated to Project X

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

If you like my content, please take a moment to view and vote on my Idea Requests: https://tinyurl.com/4rbpr7hf

View solution in original post

2 Replies

Avatar

Correct answer by
Community Advisor

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:

  • is in New or In Progress Status
  • has Planned Hours greater than 0
  • is assigned to anyone on the Project Team associated to Project X

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

If you like my content, please take a moment to view and vote on my Idea Requests: https://tinyurl.com/4rbpr7hf