Age (days) of epics and features across each Process Step throughout the lifecycle

[Muhammad Haarris Ahmed]

Hi all,

How can I extract a csv data file for all epics and features within my portfolio which provides age (days) across each Process Step throughout the lifecycle?

As part of reporting aging analysis, I need data for age (days) a particular epic or feature remained in each process step across its lifecycle.

As an example, a set of 5 epics are there in 'Closed' process step. I'd be interested to know how many days each of those 5 epics remained in 'Discovery', 'Shaping' and other process steps.

Is there any way to extract this data set in Jira Align (Standard edition)?

I came across a couple of related questions (please refer to the below links), however these answers do not talk about extracting a data set for multiple epics and features.

https://community.atlassian.com/t5/Jira-Align-questions/Get-state-changelog-of-Features-amp-Epics-from-REST-API/qaq-p/1545860?utm_source=dm&utm_medium=unpaid-social&utm_campaign=P:online*O:community*I:social_share*

https://community.atlassian.com/t5/Jira-Align-questions/How-do-I-report-on-flow-in-Jira-Align/qaq-p/1173397

Thanks.

[Allan Maxwell · Accepted solution]

As far as I know, the only way to get the time in each process step for a group of Epics or Features is through the add-on product Enterprise Insights.  You can get the total time in process from an export of your backlog, but it won't give the time in each step.  There is also the cycle-time report, but it only summarizes/averages these values.  

[Muhammad Haarris Ahmed]

Thanks Allan.