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

Shuchita Tripathi (314●3●54●92) | asked Apr 14 '15, 8:53 a.m.

Hi,

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.

Comments

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 (314●3●54●92) | 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.