It's all about the answers!

Ask a question

How to sum all work hours on JRS


roy hershkovitz (138) | asked Nov 20 '16, 1:59 a.m.
edited Sep 04 '17, 6:44 p.m. by Fariz Saracevic (904613)

 Hello, 

i started to work with the jrs .  i want to know how to sum all the work hours on tasks

One answer



permanent link
Lily Wang (4.9k714) | answered Nov 20 '16, 7:37 p.m.
In v6.0.2 when you create a JRS report, in the "Format Results" tab, you can click "Add attribute columns" and select "Type". Then click "Add Calculated value columns", select "Sum of values" and "Actual Work".
Please refer to the workshop https://jazz.net/library/article/1490

If you are using JRS 5.0.2, please refer to https://jazz.net/library/article/1470

Comments
roy hershkovitz commented Nov 22 '16, 4:49 a.m. | edited Sep 04 '17, 3:05 p.m.

 hello lily,


I Know this- How to "Calculated value columns" ...
But i Mean How to Calculated All The Tasks Under the Features .

For Example :
Features (one item) > Story (one item) >  Tasks (4 items under the section Features
Now : How to Calculated the 4 items (Tasks) just for the Feature Caller . 

Thanks . 


Lily Wang commented Nov 22 '16, 8:19 p.m. | edited Nov 22 '16, 8:21 p.m.

To achieve it, you can use Traceability links and set needed conditions.

For example, add "Child" relationship from WorkItem to WorkItem1, then add another Child relationship from WorkItem1 to WorkItem2.
In Conditions select required work item types as filter.
In Format, add Sum of Actual Work on workitem2 to calculate the total work items of the child tasks. 

Your answer


Register or to post 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.