The Atlassian Community Forums are currently in read-only mode. We will be relaunching on a new platform on September 22 (read more here). We apologize for the extended downtime. For concerns or questions, please email communitymanagers@atlassian.com. See you on the other side, on the new Atlassian Community Forums! :)

×

Forums

Articles
Create
cancel
Showing results for 
Search instead for 
Did you mean: 

How do I extract all the story points for an epic (sum up the points from the stories) ?

Christine Jouandet
June 25, 2019

Hello Atlassian community! 

In order to build a roadmap with the help of excel, I want to extract all the epics from a projet or from an increment (SAFE method) and for each, to display the story points. 

It would be the sum-up of all the story points from the stories associated to each epic.

Any idea? 

Thanks for your help!

3 answers

Comments for this post are closed

Community moderators have prevented the ability to post new answers.

5 votes
Levente Szabo _Midori_
Atlassian Partner
June 26, 2019

Hi @Christine Jouandet ,

If you need to handle many issues and like to idea to export to real Excel files, you could also take a look at our app Better Excel Exporter, which can export your issues including story point, or even use a template to create agile reports like this: 

14-jira-agile-epic-pivot-chart.png

Christine Jouandet
July 10, 2019

Thanks @Levente Szabo _Midori_  ! 

As a workaround, I already use excel, and with a pivot table, I can have the sum-up by epic.

But I would like to have it on JIRA for filter and dasboard,

 

Thanks for your help !

Christine

0 votes
Rhys Diab _Rogue Wombat Software_
Atlassian Partner
December 8, 2019

Hi Christine,

You could give Agile Docs a try.

It opens up right inside your project dashboard and gives you a report on the summed story point values of your Epics (both story point total and story points completed).

agile-docs-story-points.pngYou can also Navigate to any set of Epics using your existing Quick Filters.

Hope that helps!

Rhys

0 votes
Jack Brickey
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Champions.
June 25, 2019

you can either consider exporting all issues via a filter search and include the story points then use excel to process or consider an addon like Epic Sum Up

Christine Jouandet
June 25, 2019

Thanks Jack, 

It would be a very good idea, but I have many epics to deal with, 

Do you know if we can display the value in search results and extract it with Epic Sum up ? 

Seth B
I'm New Here
I'm New Here
Those new to the Atlassian Community have posted less than three times. Give them a warm welcome!
October 29, 2019

Epic Sum Up doesn't export properly, research before purchasing it. 

Comments for this post are closed

Community moderators have prevented the ability to post new answers.