It's all about the answers!

Ask a question

How to get a report for sum of 'Time estimated' for all work items for each user in RTC?

Shuchita Tripathi (31435492) | asked Apr 14 '15, 8:53 a.m.
I have RRDI configured in our environment.
I want a report where I can get the sum of 'Time Estimated' attribute of all the work items assigned to a user across different project areas in RTC.
Is it possible to achieve this?
If yes, how can it be done. I haven't used RRDI much.

Abhinav Mishra commented Apr 14 '15, 9:13 a.m.

From RRDI ,i am not sure how to get it done.But by using BIRT we can achieve that.

One answer

permanent link
Shuchita Tripathi (31435492) | answered Apr 14 '15, 9:52 a.m.
 I got it from RRDI.

Go to Query Studio.
From ODS -> Request Area -> Request, drag Project Name, Planned Work, Owner Name, External Key1.
Open the report in Report Studio, select Planned Work and click on Summation icon (Total)

I also Grouped on the basis of Project Area, so I got sum of 'Estimate' per project area for each user.

Your answer

Register or to post your answer.