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 |
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. |
Your answer
Dashboards and work items are no longer publicly available, so some links may be invalid. We now provide similar information through other means. Learn more here.