Timeline Page

[Jarrod Reed]

My users like the data presented on the Timeline page but I cannot extract the information in the progress column. How can I pull the data from the Timeline page into Excel?

[Sagi Gabay]

Hi Jarrod.

I don't believe we have an option to export data to Excel from the Timeline page. This should be filed/submitted as an enhancement request.

@Nate Bever 

Can you confirm that?  Do we have plans already to add this capability to that page?

Thanks.

Sagi

[Nate Bever]

Hey Jarrod,

I apologize for the delay in response, but I assume that what you're looking for is the labeling that is found in the "Progress" column.  (Not Started, Late, Blocked).  All the other data is easy to pull from the API or the Portfolio Items tab with the columns you want to see - including the raw "Progress" percentage.  (The attribute is called: "PercentDoneByStoryCount")

The labels, however, are calculated and unfortunately not part of the API.  You can find the logic in the documentation for the Timeline page.  Here is the applicable portion that explains it:

• Not Started: No child work items have been started for this portfolio item.
• Blocked: The portfolio item is blocked. Blocking the portfolio item does not block the child work items. Learn more.
• Late: Work is not being accepted at a sufficient rate to complete the portfolio item before the Planned End Date. Considering the current date and the timeframe for the portfolio item, the rate of work being accepted is more than 40% lower than the necessary rate of acceptance in order to complete the portfolio item before the Planned End Date.

-Nate