It's all about the answers!

Ask a question

Is it possible to create WI Report in RRDI/Insight with cumulative time spent in a date range.?


Nagesh Srinivas (10838) | asked Jan 24 '15, 7:37 a.m.
Is it possible to create a  report in RRDI/insight to create WI report with cumulative time spent on a WI between a date range.?

Something like below...


or


Accepted answer


permanent link
Jackie Albert (1.6k14946) | answered Jan 26 '15, 12:08 p.m.
edited Jan 26 '15, 12:13 p.m.
Nagesh,
Yes, I put together a sample of something similar using the 'Request History' in RRDI/Insight to show how this might be done. 

I pulled in the following Data Items from Request History  (Under Request Area in the Operational Data Store), adding in the appropriate filters to limit to the data I wanted - in your instance that would be the date range.  Make sure to set the aggregation properties on the Actual Work field  (where the 'Time Spent' from RTC goes) so this works properly.


On the report page, I created a Crosstab using the data items from my query
 

Here's the output shown for my sample data.
 

Or, you could use the List option with the same query to get a slightly different result that you might prefer
 

Hope this helps.

Nagesh Srinivas selected this answer as the correct answer

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.