How do I get Epic progress % to show in Jira issues macro?

Question

I'm trying to get a report of all epics in a project and their percent complete based on issue status. I'd like the report to update automatically so I don't have to manually input data each week.

I have a Jira issues macro in Confluence and the JQL is

project = XXX AND issuetype = Epic

I have the columns configured to show

Progress

But, the progress fields are blank and I cannot figure out why.

When I go to Jira and click on an actual epic in that project, it shows the progress bar.

I'm trying to get that 45% done stat to populate into a report.

Is there a way to do this without buying a marketplace app?

Sarah Mossembekker_pltia5 · Answer

I think I found a workaround that is okay (not the prettiest, but free).

I found this knowledgebase that I used. It combos a custom field with an automation to calculate a percent complete based on the issues' status in that epic.

Here's how I set up the automation. I had to play with it a bit. Don't mind the second piece (I only wanted my automation to apply to certain categories of projects in Jira).

Then I did the Jira issues macro in Confluence and it created this table.

Oh, and to get the rule to run on the issues that were already done I did a search for Done issues in that project, bulk edited them to transition to To Do. Then did a new search for issues in that project that had a status changed in the last 2 minutes and bulk edited them to transition back to a Done status and then the automation rule kicked in.

I think long term I might look into a paid dashboard that looks better, but I think the table is good enough for now, I'm just happy it will automatically update.

Sarah Mossembekker_pltia5 · Answer

Thanks for the info, I think you're right about the time estimates. We aren't using those fields.

Danut M _StonikByte_ · Answer

Hi @Sarah Mossembekker,

I think that Progress columns are empty because they use time estimates (Original Estimate vs Time Spent vs Remaining). And I'm afraid that it cannot be configured to use issue count instead of time estimates...

You could look on Advanced Roadmaps (requires Jira Premium plan), I think it has this capability! Or, you can search for a plugin on Atlassian Marketplace.

If you decide to use a plugin, our Great Gadgets app offers a Pivot Table & Pivot Chart gadget/macro that can display the progress of the epics based on child issues by issue count, sum of story points, percentage completion in form of multi-dimensional tables, heat-map tables, or charts of various types.

As you can see in these example, the % completion (on Done column) is calculated automatically for each epic, in real-time with no extra work.

If you have questions, feel free to contact support@stonikbyte.com at any time.

Danut.