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