Is it possible to create WI Report in RRDI/Insight with cumulative time spent in a date range.?
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
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
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.