Rally Software

Expand all | Collapse all

Need help extracting Schedule State Cycle Time data from Excel Add In or Lookback API

  • 1.  Need help extracting Schedule State Cycle Time data from Excel Add In or Lookback API

    Posted 02-24-2018 10:09 AM

    I would like to generate a list of work items (User Stories, Defects, Tasks) that include the following for each:

     

    FormattedIDStateStateValueStartDateEndDate
    US35239ScheduleStateBacklog8/31/2017 8:0811/27/2017 1:46
    US35239ScheduleStateDefined11/27/2017 1:4612/4/2017 5:20
    US35239ScheduleStateIn-Progress12/4/2017 5:2012/11/2017 7:43
    US35239ScheduleStateCompleted12/11/2017 7:4312/12/2017 8:08
    US35239ScheduleStateAccepted12/12/2017 8:08

     

    I have been unsucessful creating this through the Excel Add-In and I am getting lost quickly in the lookback API document as I couldn't find any relevant query examples there either.

     

    I know this can be accomplished directly through agile central using the custom page "Cycle Time Data App" but I would rather not have to pull in that specific data out of Agile Central when everything else i need comes directly from the Ecxel Add In.

     

    Any assistance would be greatly appreciated.



  • 2.  Re: Need help extracting Schedule State Cycle Time data from Excel Add In or Lookback API

    Posted 03-23-2018 05:17 PM

    You would have to use the Lookback API to get the data for all of those state changes.  I'm not a lookback api guy.  It's very complex (at least the ones I've looked at) and even the Agile Central guru's don't get it right all the time (case in point, many of the lookback apps don't ignore deleted artifacts).  If you can settle for just cycle time from In-Process to Accepted, you can do it with Excel.  There are dates in the user story for In-Progress Date and Accepted Date.  You simply have to do the math for the difference of the two dates, ignoring any non-working days.  I've written that formula before in Excel so I know it can be done.