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

Question

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.

Asia Pham · Answer

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

Gregory_8xb0cr · Answer

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

SIMON PATENAUDE · Answer

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.