How to build a jira epic report with % completion based on issues?

[Philippe Vignol]

Hi everyone,

I’m new to Jira and trying to create a Jira epic report that shows progress based on the number of completed issues within each Epic.

For example, I have around 5 epics, and each epic is linked (via the Epic Link field) to multiple stories and bugs. I’d like to generate a progress report that displays % complete for every epic based on how many issues are done vs total.

I’m not sure if this can be done with standard Jira reports or dashboards, as I can’t find a clear built-in jira epic report that shows this view in a simple way.

Is there an out-of-the-box solution in Jira for this? And if not, I’m open to Marketplace apps that provide more advanced epic-level reporting and visual charts.

[Rahul_RVS]

Hi @Philippe Vignol 

The new Jira Summary does give Epic progress based on child issues. Not sure if it works for linked issues as well. If you are open to try out an alternate mktplace solution to view Epic progress based on child issues and cross project linked issues take a look at,

Issue Hierarchy

The app allows you to view your issues in a tree view along with the linked issues shown as child issue. Also you can filter your child issues as shown below.

In the hierarchy view you can view the % progress of your child issues as well. The app sums up the time spent / story points at each parent level. You can also view "%Completed" at each parent level based on status of child issues as per your requirement.

Do give it a try.

Disclaimer : I am one of the app team member

 

[Danut M _StonikByte_]

Hi @Philippe Vignol,

Welcome to the Atlassian Community!

You could try using the Two Dimensional Filter Statistics gadget of Jira. It can display the number of issues in every epic and status.

But unfortunately this gadget does not display % complete (percentages).

If you need more than this, then I would recommend searching for a plugin (app) on Atlassian Marketplace that is capable to display percentages. 

If you are willing to try a plugin, our Great Gadgets app offers a Pivot Table & Pivot Chat gadget that can display % complete for each epic based on number of tasks, or by sum of story points of the tasks.

It can display the data as a table, heatmap table, or chart.

For more details and how to do this by using our app, see this article: https://community.atlassian.com/forums/App-Central-articles/How-to-display-the-progress-of-Epics-or-Initiatives-in-Jira-or/ba-p/2858840

if you have any questions or need help, feel free to contact us at support@stonikbyte.com at any time.

Danut.

[Gerda Grantiņa]

Hi @Philippe Vignol 
If you are willing to try an Atlassian Marketplace app, check out eazyBI for Jira Cloud. 

Use Epic Link in report rows, and add measures such as Issues created and Issues resolved to see the counts of issues included in the epics. You can also create a custom MDX formula to calculate the percentage of resolved issues:

CASE WHEN
-- avoid division by zero
[Measures].[Issues created] > 0
THEN
-- if no resolved issues, will use 0
CoalesceEmpty([Measures].[Issues resolved], 0)
/
[Measures].[Issues created]
END

Here you can see a demo example of a similar report, only it is using Story points measures available in eazyBI: https://eazybi.com/accounts/1000/cubes/Issues/reports/166439-story-points-progress-and-velocity-by-sprints-in-epic

If you have any questions regarding the reports, write to support@eazybi.com, and we will be happy to help!

Best,

Gerda // eazyBI support

[Vasyl Krokha _Broken Build_]

Hi Philippe  👋

The challenge: You need a progress report showing % completion for multiple epics, measured by the number of child issues (stories, bugs) completed under each epic - without scripts or complex workarounds.

Unfortunately, Jira's native Epic Report is quite limited here - it only works with one epic at a time, uses default estimation fields, and doesn't offer percentage views or multi-epic comparisons.

A straightforward way to solve this is with the Epic progress report from Agile Velocity Charts. It visualizes completed work across multiple epics at once, broken down per epic.

You can set the estimation field to Issue count, so progress is calculated based on the number of issues completed rather than story points. The chart also supports a percentage view, giving you exactly the "% complete" perspective you described.

You can also click any interval to drill down into the individual issues driving that progress.

📖 Helpful documentation: ≈ interactive Epic progress report example 

There's also an interactive Epic progress report example - a clickable demo you can explore to see how the chart works in practice.

If you need even more charts for Epic reports (burnup/burndown, cumulative flow, Monte Carlo), the Agile Reports and Gadgets bundle covers all of them.

Feel free to follow up if you have any questions about the setup! 🙂

[Arkadiusz Wroblewski]

Hello @Philippe Vignol 

Yes is possible with out of Box solution.

If you want a simple “% complete per Epic” view for multiple epics, the clean Cloud way will be (Take that as example)

Create a Number field: Epic % Complete (or Epic Progress %)

Automation rule (project-level or global):

Trigger: Scheduled (daily) or “Issue transitioned” (if you want it more real-time)

Lookup issues (this is the important part) with JQL like:

issuetype in (Story,Bug,Task) AND "Epic Link" = {{issue.key}}

(This runs when the rule is iterating epics, see next step.)

Branch: “For JQL / Lookup issues” is one way, but the easiest is:

Run the rule on Epics (scheduled JQL): issuetype = Epic AND project = XYZ

Inside that loop, do a Lookup issues for the children of that epic (JQL above)

Calculate Done vs Total

Total = {{lookupIssues.size}}

Done = count issues where statusCategory = Done

{{lookupIssues.statusCategory("Done").size}}

Write back to the Epic

Edit issue → set Epic % Complete to something like:

If total = 0 → 0

Else → (done / total) * 100

That gives you a real numeric % on the Epic, so you can show a filter of epics in a dashboard gadget/table and display the field.

eazy BI could do work too.