Rally Software

 View Only
  • 1.  Rally Export

    Posted Jun 19, 2019 09:14 PM
    ​Would it be possible to export data from Rally to get the following data?

    Portfolio
    User Story
    BA Planned hours
    Dev Planned hours
    QA Planned hours
    Task name
    Task Estimated
    Task To do


  • 2.  RE: Rally Export

    Posted Jun 20, 2019 09:02 AM
    ​Hi Ashok - The Rally Excel Add-In may be able to handle this.

    ------------------------------
    Agile Coach
    Boston, MA
    ------------------------------



  • 3.  RE: Rally Export
    Best Answer

    Posted Jun 20, 2019 09:45 AM
    Excel Add-In allows users to export one type at a time. So, if you generate query in Excel Add-In you will need to create 3 distinct queries - Portfolio Item Feature, User Stories and Tasks and then merge data together.

    To get three levels of "type" in one query download the Custom List with Deep Export which is available in the App Catalog. Your data will extract rows as follows: 

    • F1234 with columns (e.g. data elements from feature type)
    • F1234 US5678 with columns (e.g. data elements from user story type)
    • F1234 US5678 TA9000 with columns (e.g. data elements from task type)

    Caveats: 1) you must place filters on the data; for example by timeboxes (release or iterations), owner, etc. Otherwise, query will pull all data from beginning of time, 2) You can extract data from each type - feature (e.g. planned start/end dates), user story (plan estimates, acceptance criteria, etc.) and task level (state, actual hours, to do hours, etc.). Therefore, you should limit the number of columns which add to query. More columns means slower response time, 3) Query works well with Chrome or Firefox. IE just doesn't work; slow response time which results in an error message.