RRDI For getting hours submitted in child workitems
I have a workitem that have several "child" in the Links section.
In those child I have submitted hours in the time tracking tab.
I want to know if its possible using RRDI (the solution for custom reporting in the new CLM) that I can search how many hours are being submitted for the specific parent link?
For example :
Parent 1
Child 1.a : 2 hours
Child 1.b : 3 hours
Parent 2
Child 2.a : 3 hours
Child 2.b : 8 hours
Child 2.c : 2 hours
And in the report I will like something like :
Parent 1 : 5 hours
Parent 2 : 13 hours
In those child I have submitted hours in the time tracking tab.
I want to know if its possible using RRDI (the solution for custom reporting in the new CLM) that I can search how many hours are being submitted for the specific parent link?
For example :
Parent 1
Child 1.a : 2 hours
Child 1.b : 3 hours
Parent 2
Child 2.a : 3 hours
Child 2.b : 8 hours
Child 2.c : 2 hours
And in the report I will like something like :
Parent 1 : 5 hours
Parent 2 : 13 hours
One answer
Hello.
Yes, this is possible. Create a query in Report Studio that uses the
"Request Related Requests" query subject and create a Rollup Aggregate
Function on Planned Work of the children to get to the sums for each
parent.
Also see these posts for discussions about hierarchies:
- https://jazz.net/forums/viewtopic.php?p=62233
- https://jazz.net/forums/viewtopic.php?t=18941
Hope this helps,
Peter.
Yes, this is possible. Create a query in Report Studio that uses the
"Request Related Requests" query subject and create a Rollup Aggregate
Function on Planned Work of the children to get to the sums for each
parent.
Also see these posts for discussions about hierarchies:
- https://jazz.net/forums/viewtopic.php?p=62233
- https://jazz.net/forums/viewtopic.php?t=18941
Hope this helps,
Peter.