Create
cancel
Showing results for 
Search instead for 
Did you mean: 
Sign up Log in

It's not the same without you

Join the community to find out what other Atlassian users are discussing, debating and creating.

Atlassian Community Hero Image Collage

How to automate the sum of story points for all issues under the epic?

Edited

I would like to know if there is a way I can automate the sum of story points for each issue under the epic?

For example, if I have a task and a bug card each worth 2 story points each, can this be totaled on the epic (parent) level to read 4?

If not possible for all issues, can this be done for tasks only under the epic (not subtasks)? 

Hope this makes sense to more experiences users.

Many thanks

5 answers

1 accepted

@hassan.ahmed you can do this with Automation rules with the following rule, assuming you are using Jira Cloud:

Whenever the Story Points field changes, branch the rule for the related Epic and then sum all the Story Points for issues belonging to the Epic.

The following screenshot show how this would look:

Screenshot 2021-02-10 at 14.01.08.png

Thank you for the suggestion @Gareth Cantrell . This works great! 

 

Like Gareth Cantrell likes this

Hello,

trying to create the same rule but couldn't get this lookup Issue component, is there any other alternative for this.

Can refer the following screenshot of my rule.sum up rule.png

@Mohini Chandwani Hi Mohini.

  • Remove the "If" issue so the "for epic (parent)" branches off the first step.
  • Then press "new actions" > "lookup issues" and type "Epic Link" = {{issue.key}} > save 
  • "new action" > "edit issue" and search story points
  • type in {{look up issue code}} and save
Like Steffen Opel _Utoolity_ likes this

Even after removing the "If" condition didn't get the option of "lookup issues".

look up issue.png

Is this related to scope or access?

When you press new action you should see these options? 

image.png

@Mohini Chandwani I see you tagged your original question as Cloud, however your screenshot suggests you're using the Server version.

Unfortunately the Lookup issues action is not yet available on the Server version.

This can be achieved in the Server version using a Send web request to query the Jira Software REST API in place of the Lookup issues action.

In the following rule, I'm using a web request to the same Jira instance using the Webhook URL: {{baseUrl}}/rest/agile/1.0/epic/{{issue.key}}/issue?maxResults=100 where {{issue.key}} is referring to the Epic in the branch rule.

You also need to set the Authorization header using base64-encoded credentials of a user with access to the project.

Additionally, you need to select the Wait for response option.

Screenshot 2021-02-11 at 15.14.55.png

The final piece of the puzzle is to use the response from the web request to sum up the story points into the Epic.

In my instance, the custom field id of the Story Points field is customfield_10106.

Screenshot 2021-02-11 at 15.15.09.png

Like # people like this

Hello,

I have tried the same, but it throws the error - Response HTTP status : 500 and same Webhook URL run in the browser and getting the data.

And in header I have provided Authorization and encoded {username:password}, other steps are same but still the same error.

 

 

Thank you for your valuable suggestions.

@Mohini Chandwani The only thing I can suggest is to make sure the {{baseUrl}} is what you expect it to be (you can do this using the Log action component).

It can happen depending on how your instance and any proxies are configured, that you may need to use http://localhost:8080 instead of {{baseUrl}}.

Thank you @Gareth Cantrell for all your suggestions, the issue was in the baseURL but it is resolved.

Rule is working correct.

 

Thanks.

Like Gareth Cantrell likes this

Hello @Gareth Cantrell

Is there any way to send email when rule gets failed or any error occurs.

Can we keep the check for Audit log status whether the rule is ran successfully or some error occured.

I have tried the following approach but it is not sending mail.

mail.png

Any open suggestion with better option which has quick implementation is welcome.

Thanks.

Hi @Mohini Chandwani 

In the rule details section, you can select to be notified if the rule fails and select the rule owner who will receive these notifications as in the below screenshot:

Screenshot 2021-07-10 at 21.02.47.png

Hi Gareth Cantrell,

Have tried the same but it is not sending the mail.

Is there any way to access the audit log status value like "SUCCESS" or "SOME ERRORS" so that we can send the mail based on status response, I have tried to console like {{Audit log.Status}} etc various combinations but didn't print anything.

Let me know if it is possible.

 

Thanks for always responding!

@Mohini Chandwani you could try looking at {{webhookResponse.status}} which will return the HTTP Status code for last web request action. 

I was trying different proposals but it does set the sum value of story points to the epic. 

See my logic here

image.png

and here

image.png

so when the rule is enabled and I set or change story points in a story I'm getting no error

image.png

but when I reload the epic and check for the story points field, it remains empty

image.png

 

Did I misunderstood something, do you see an error in my logic or do you have a proposal on how to proceed?

Thx

@Gareth Cantrell 

Thank you for the workaround for summing story points into the Epic story points field! I am using JIRA server so I've been looking for a solution to this issue.

My rule runs without errors but the story point field in the Epic that should be updated is not being updated. Furthermore, if the Epic has a story point value it is erased when this rule runs.

Here is a screenshot of the rule. Any ideas?

Automation.PNG

@Wyner_ Zachary G_ I'd suggest adding a Log action after the Send web request action and the log the value of your custom field from the web response to make sure the values you are getting back are what you are expecting to see.

@Gareth Cantrell  Thanks for the fast response! I added a log action but it seems like the value being returned by the web request is the story point value for the epic, which is null.

Automation2.PNG

@Wyner_ Zachary G_ as you say, you're logging the field in the epic. Try logging the response from the web request instead: {{webhookResponse.body.issues.fields.customfield_10002}}

@Gareth Cantrell 

Getting closer! According to the log, the web request is retrieving the values I am expecting and the rule successfully executes. However, it still nulls out any value in the Epic "story points" field rather than summing the story point values from each story.

Automation3.PNG

@Gareth Cantrell 

Just letting you know I got the rule to work! I had to change the formula in the edit issue fields action to this:

{{webhookResponse.body.issues.fields.customfield_10002.join("+")}}

Thanks for your help!

-Zac

Like Gareth Cantrell likes this

Great to hear you managed to get it working, although I am surprised the sum() function didn't work for you.

May be worth raising a support request with Atlassian to investigate.

Cheers,

Gareth

Hi @Wyner_ Zachary G_,

I guess the problem is in the web request URL, it is returning null because you didn't mention customfield of Story point to retrieve the story point value from those issues.

Can you just try these once -  {{baseUrl}}/rest/agile/1.0/epic/{{issue.key}}/issue?customfield_10002 it will return the story point values of all child of their Epic parent.

sum function should work, I am using the same approach it adds all the child story points and total will be added to respective epic parent.

refer the below snap.

story point.png

Hope it should work.

0 votes
Rahul_RVS_Support Marketplace Partner Apr 06, 2021

Hi

You can try out our add-on to track progress of issues in Epic hierarchy on time estimates and at story points as well.

Agile Tools - Epic Tree and Time in Status 

The add-on allows you to manage and visualize your Epics with rolled up estimate progress reports along with multiple Time in Status Reports ( more than 6 reports).

Key features:

  • Epic Hierarchy
    • Epic Sum up - Roll up for Time estimates and Story Points
    • Excel like editing for key fields
    • Excel export of hierarchy dataProgress % on "remaining estimate" or "original estimates"
    • Include all issue types vs only Stories in Story Points roll up
    • Support for custom names for Epic & Story fields

     

  • Multiple Time in Status reports
    • Report Types
      • Time in Status
      • Time with Assignee
      • Time in Status with Assignee
      • Time with Assignee per Status
      • Status/Assignee Count
      • Multiple Transition Reports

       

    • Configurable working hours/days
    • Excel export

     

  • Transitions tracking on issue screen
    • Status/ Assignee Transition : Status/Assignee changes with average time and count per status. Option to switch between Graphical and tabular view.
    • Epic Tree on Issue Screen

 

Epic Hierarchy Screen_Server_Latest.PNG

 

TISwA-5-Apr.PNG

0 votes
Jack Brickey Community Leader Feb 10, 2021

Maybe consider the Epic Sum Up addon. There is a lite (free version) - epic-sum-up-light 

Suggest an answer

Log in or Sign up to answer
TAGS
Community showcase
Published in Jira Automation

New to Jira Automation - goodbye Cron (sort of), hello new project created trigger, new additions to

Hey Everyone! Simeon from the Automation team here. I'm delighted to share some new features and improvements that we are shipping to Jira automation (Cloud only). Firstly, @Sam Harding&nbsp...

2,795 views 10 23
Read article

Community Events

Connect with like-minded Atlassian users at free events near you!

Find an event

Connect with like-minded Atlassian users at free events near you!

Unfortunately there are no Community Events near you at the moment.

Host an event

You're one step closer to meeting fellow Atlassian users at your local event. Learn more about Community Events

Events near you