nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

how can i track the percentage of completion of an epic in Jira next gen?

Luca Orciuolo

Hello,

I would like to know if there's an add-on or else that can help me to track the percentage of completion of an epic (I don't mind about stories and sub tasks).

I would like to manage the progresses of epics and transfer it to excel automatically while keep tracking and working on my project in Jira next gen.

hope you can help me, thank you

Accepted answers

All comments

Nic Brough -Adaptavist-

How are you measuring "completion"?

Luca Orciuolo

Well, I actually don't know yet. I was thinking I could create a ratio based on story points estimate but it's not a real solution since it is a "weight" not a measure of time.

Another thing i thought was creating a simple ratio based on start and finish date [(today-start date)/(finish date- start date)] but in this case i would make a strong assumption stating the same amount of work performed each day.

In this sense, I would like your suggestion.

Thank you

Eoin

@Luca Orciuolo we've introduced a progress bar in the issue view over the Child issues panel. This is currently using issue count only, and we are investigating making this a toggle for story points estimation as well.

Cheers

Luca Orciuolo

Thanks mr Ryan, but I think that's not exactly what I need.

I would like to record the % of epic progresses as the project goes on.

Maybe there's an add-on that fits my needs.

regards

Eoin

We will be looking to include an epic burndown chart in next-gen in the longer term.

In the meantime there is an Atlassian built integration for Jira and Google Sheets that may help in the short term... https://gsuite.google.com/marketplace/app/jira_cloud_for_sheets/1065669263016

some more info on this in our Community... https://community.atlassian.com/t5/Jira-articles/Try-the-new-Jira-Cloud-add-on-for-Google-Sheets/ba-p/1016436
And here is some examples for how to use the JIRA() function to import data from Jira with more advanced options than what the add-on's sidebar currently supports https://docs.google.com/spreadsheets/d/11jc9CPnBt1KWhRlaO5nnNSFkV5LR3lFjMV7_i6uMB_k/edit#gid=490120907

Nic Brough -Adaptavist-

There are a couple of ways to track "progress", but it very much depends on your processes and what you really think it is.

Your idea about start and end date is quite good, as it's measuring elapsed time

The most simple measure is the number of open and "done" stories in the Epic, but this takes no account of size

Story points, while not really a measure of time (as you say, it's more about "weight") is still quite a good way to do it, as it gives you a good idea of relativity

A very good one is estimates and work-logs (usually done at a sub-task level if you're being a bit scrum-like)

April Carreon

Hi All - I am keen on surfacing the % complete in the EPIC in the google sheets using the jira_cloud_for_sheets. Can you guys let me know what field this is and how I can show it in my google sheet?

Image 19-11-19 at 3.37 pm.jpg

Rachael Garbee

@Eoin I'm also looking for the field that I would pull into a Google Sheet from the Sheets for Jira integration. What field matches the "Issues in this epic" Progress Bar %?