What is the best way to track which Sprints an Epic was part of?

[Vikrant Yadav]

In our organisation, One Epic completes in multiple Sprints 1,2,3,4
SPrints have Story
what is the best way to track the Epic is a part of which which sprint ?
How can i track progress of each sprint from epic?

Kisly suggest and make it gramemr free also
and Suggst a solution also

Kindly help me with sample video if possible. 

[Alina Chyzh_Grandia Solutions]

This is a common gap in Jira's native reporting.

Native JQL workaround

You can't query an Epic's sprint history directly, but you can query its child stories:

issueType = Story AND "Epic Link" = EPIC-123 ORDER BY sprint ASC

Switch to list view, add the Sprint column, you'll see which sprints each story touched. It works, but you'd need to run this manually every time.

A faster way with Report Hub

If you need this view regularly, the app Report Hub for Jira Cloud was created by our team. It has a Created vs Resolved chart and a custom table report where you can:

• Set the data source to your project
• Group issues by Epic and Sprint
• Filter by issue type = Story
• See resolved vs. total per sprint, per Epic — in one view

You configure it once, save it, and reuse it every sprint without touching JQL again. There's a free tier if you want to try it.

Hope that helps!

[Danut M _StonikByte_]

Hi @Vikrant Yadav,

You might be able to get something by using the Two Dimensional Filter Statistics  gadget:

• create and save a filter in Jira that returns the stories from your project(s) that are done

project = DEMO AND issueType IN standardIssueTypes() AND parent IS NOT EMPTY AND statusCategory = Done

•  add the Two Dimensional Filter Statistics gadget to a Jira dashboard
• configure it to use the filter created and display stats by Parent and Sprint 

• as a result you will get this view that shows, for each epic, the number of stories fixed in each sprint

If you use want this stat by sum completed story points, the solution would be to search for an app (plugin) on Atlassian Marketplace.

In case you want decide to use an app, you can also do this (by both issue count and sum of story points) by using the Pivot Table & Pivot Chart gadget offered by our Great Gadgets app. 

To get this the gadget should be configured like this:

Hope this helps.

Danut.  

[Rahul_RVS]

Hi  @Vikrant Yadav 

You can use Jira Rest Api's to pull this information and build your own custom solution.

However if you need detailed reporting to track changes for multiple issues, you may want to have a look at a mktplace app for the same.

We have built an app to extract changelog data in a simple and easy to use interface. The data can be exported to a CSV file as well.

It provides complete details of who changed the data, what was changed and when. 

Issue History Reports

Do give it a try.

Disclaimer : I am part of the app dev team