nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

How to calculate the sum of stories part of an Epic

Émile Robillard_zrbfgr

Hello everyone!

I am currently trying to calculate how many story points are part of each epic in a field. Basically, I'm trying to see what effort was made in each Epic.

I have tried using the automation without success, what would be the best solution to achieve that?

Thank you!

Accepted answers

All comments

Petter Gonçalves

Hello @Émile Robillard

Welcome to the Atlassian Community!

You can sum the story points of Stories related to an Epic by using the {{lookupIssues}} action in Jira Automation, together with the following smart values:

{{lookupIssues.Story Points.sum}}  -> for classic projects
{{lookupIssues.Story point estimate.sum}} -> for NextGen projects

Allow me to provide you with a practical example:

Let's suppose you're using a Classic project, where you want to sum the Story point of the child issues to its related Epic when that Epic is transitioned to "Work in Progress". These would be the steps:

Navigate to your Project > Project settings > Automation
Create a new rule using the template below:

Alternatively, you can use the third-party app Epic Sum-up which has a free and a paid version with more features (reports, screens, etc).

Let us know if you have any questions.

Émile Robillard_zrbfgr

Thanks @Petter Gonçalves !

So if I am using a next-gen project and would like to update the Story Point Estimate of an epic each time I update the story points estimate of a child story, what template should I use for automation?

Thanks!

Cobus_r6i7xq

Hi @Petter Gonçalves I have set the automation like you suggested, with one exception. We use Features as our main task and then link the stories to the feature. The story points in the feature does not update as suggested in the example. Could you perhaps assist?

Cobus

Rahul_RVS

As an alternative, you may want to try out our add-on to manage multiple Epics and their hierarchy on a single page.

Agile Tools - Epic Tree and Time in Status

Manage and visualize your Epics with rolled up estimate progress reports.

Below are the key features:

Epic Sum
Configure progress % calculation on either "remaining estimate" or "original estimates"
Epic Tree directly on Issue Screen
Display and manage Epics/Issues of your project
Real time edit option for Issue summary, status, time estimates, story points and assignee on the tree on the Epic Hierarchy
Rolled up percentage completion and at issue level as well
JQL support for Epic Hierarchy screen
Time in Status report using JQL
Issue Tracker to view complete transitions on your issue screen
- Status Transition : View all the status changes in a single tab along with average time and count in each status. Switch between graphical and tabular view to make more out of the data.
- Assignee Transition : View all the assignees for the issue along with the time for which the issue was with each assignee. Switch between graphical and tabular view to make more out of the data.

Epic Hierarchy Screen_Cloud_Edit.png

Epic Hierarchy_Issue Screen_Cloud.PNG

Petter Gonçalves

Hello Cobus,

I'm not sure if the same function might work for the feature issue type as it has a different hierarchy link, but I know Story points fields are only applied to Story and Epic issue types by default, as mentioned in the documentation below:

Configure estimation and tracking

That being said, please ensure your Story points field context is properly applied to the Feature issue type, by following the documentation below:

Edit a custom field context

Once you confirm the field is properly applied to the feature issue type, please try to configure the automation rule and check if it properly works.

Welcome!

It looks like you're new here. Sign in or register to get started.

Quick Links

Find more posts tagged with

cloud

jira-software

jira-software-cloud

atl-gruland