Epic delivery progress by Sprint - Story Points - Multiple Epics

[Kenny Grant]

Hi, we're looking to create a report/view that shows Epic delivery progress. An overview where we can see all Epics and what Story Points have been delivered in which Sprint.

This is for management of Epics and it's important to have all required Epics in the report - one reason why the built in Epic Burndown is not suitable. I guess this would require some sort of custom report though I'm not sure where to start - an add-in, looking at plans, JQL etc.

A report/dashboard would be ideal though if it's only possible to get the data for export that would do - as long as it's repeatable easily. I've attached mock-up of what it might look like.

[Danut M _StonikByte_ · Accepted solution]

Hi @Kenny Grant,

Welcome to the Atlassian Community!

Unfortunately, you can't do this using the built-in Jira reports or gadgets. You will need an add-on from Atlassian Marketplace.

If you consider the option of using an add-on, our Great Gadgets app has a Pivot Table & Pivot Chart gadget that will allow you to display the epic delivery progress by sprint- it works just like pivot tables in Excel and allows you to display data in form of table, heat-map tables or charts. 

To obtain this, the gadget should be configured like this:

Unfortunately it is not possible to display Total and Remaining in the same table/chart. 

But you can configure a different instance of the gadget to display the overall epic progress by sum of story points of percentage completion. 

If you need any assistance with the configuration, feel free to contact us as support@stonikbyte.com.     

Danut.

[Kenny Grant]

Thanks Danut, will have a look at this. It's a corporate instance so add-ins will be difficult

[Dmitry Astapkovich _Colined_]

Hi @Kenny Grant , 

It's kind of possible to achieve but strongly depends on how accurate and well organized your data is. Couple of thing to keep in mind:

 - sub-task can't be assigned to sprints directly. Instead they are using parent sprint

 - if a story/task has multiple sprints (drifting between sprints), it becomes really tricky to map that progress correctly. Especially with the comment above, if you have multiple sub-tasks, completed in different sprints 

This being said, you can take a look on Pivot Report we develop. I don't have accurate demo data, but here's what you can get in several clicks:



We can schedule a call to go over the demo if needed. Hope it helps!

[Kenny Grant]

Thanks Dmitry will take a look also

[Marc - Devoteam]

Hi @Kenny Grant 

Welcome to the community.

This is more BI related than a simple dashboard option.

This requires calculation on different levels.

Are you using a BI tool in your company, of so there are multiple 3rd party solution to get the data out to such tools.

In the Bi application, you could create a report as required.

[Kenny Grant]

That might be an option for us Marc, though I'd need to get the data out first right? Or would that be a simple export

[Marc - Devoteam]

Hi @Kenny Grant 

Yes you would need to get the data out first.