How to get lead time of WI in report?
![]()
Hello
do you have any idea how to get lead time of WI in report? WIs have states: Backlog, In progress, Ready to review, Done. Lead time means number of hours/days from state's change "Backlog->In progress" to state's change "Ready for review -> Done". I cannot find how to create dataset defined as SQL SELECT in report designer?!? Thank you in advance David Csikkel |
2 answers
![]()
On 5/13/2010 3:23 AM, David.Csikkel wrote:
Hello You can't do full SQL in the report designer. Our data sets automatically create the appropriate SQL queries based on a somewhat simplified user experience. However, the data you need is there. The Workitem_Chngs table contains the history of each work item, including states, and has both the pre- and post-change values. So you want to select from that table where the prev_state is Backlog and state is In Progress (given your example above), and again where prev_state is Ready for Review" and state is Done. Then you can correlate the values in the report and calculate the lead time. james RTC Reports Team Lead |
![]()
Thank you for advices.
I have created 3 datasets, one for Backlog -> In progress change and second one for Ready to review -> Done change And finally third join dataset. Report is working now but... :-) Where can I find storypoints? I want to recalculate lead time of story per storypoint. T.I.A |
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.