Any way to display progress of an epic or milestone in a custom field using JQL?

[David Calabrese]

We're looking to find a way to display the progress of completed child issues within a parent issue. For example, the progress of users stories within an epic. However, we would like to know if there is a way to display that progress using a custom field that  runs a JQL query to pull those child issues and display that progress in the custom field on the epic. 

[Dave Mathijs]

Hi @David Calabrese 

The Roadmap view/feature shows you the progress of the issues in an Epic.

Have you enabled it?

[Benjamin]

Hi @David Calabrese ,

Currently, user can see the link issues statuses on the Epic. Also, if you are using a scrum board, there is an Epic progress bar and the number of issues completed and outstanding. Is there something outside of this?

Thanks,

Ben

[SIMON PATENAUDE]

Hi @Benjamin and @Dave Mathijs 

I have a similar requirement. My team is using Jira to manage our work, but we are interfacing with construction teams who are not on Jira. I created a google spreadsheet with Jira Cloud for Sheets that pulls the Epics with their respective Start/Due dates. These dates are derived from the Jira Roadmap.

I use the spreadsheet to share with the steering comity to show our planned deliverables. 

The ability to export the % done that epics display in the Jira Epic View would help me illustrate if a deliverable is at risk. In this example below, I hope to extract the “40% Done”

Using spreadsheet formulas, I can sort of calculate the information, but it's unreliable. 

[Gregory]

Hello @SIMON PATENAUDE 

I'm currently facing the same need, did you came up with a solution to export the epic completion rate into a google sheet ?

Thanks 

Gregory 

[Asia Pham]

Hi @David Calabrese , @Gregory  

I know this question is a bit old, but I wanted to share an update that might still be helpful 

If your goal is to visually track the progress percentage of child issues within a parent (for example, stories within an Epic), you may want to look at TeamBoard ProScheduler instead of relying on custom fields.

This app can automatically calculate Epic progress percentage based on child issues and display it directly on a Gantt chart with percent-complete bars. Additionally, you can export your data to Excel or PDF

Thanks