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

Earn badges and make progress

You're on your way to the next level! Join the Kudos program to earn points and save your progress.

Deleted user Avatar
Deleted user

Level 1: Seed

25 / 150 points

Next: Root


1 badge earned


Participate in fun challenges

Challenges come and go, but your rewards stay with you. Do more to earn more!


Gift kudos to your peers

What goes around comes around! Share the love by gifting kudos to your peers.


Rise up in the ranks

Keep earning points to reach the top of the leaderboard. It resets every quarter so you always have a chance!


JQL Query for Summing Completed Story Points Per Assignee

With the following JQL Query, per assignee, I am able to get the count of completed issues, where story points are greater than zero:"21" and assignee="Chris Mazzochi" and "Story Points" > 0 and resolution="done"

But how do I get the result to return the total, of those story points, for the completed issues?

Thank you, 
C. Mazzochi



9 answers

2 accepted

10 votes
Answer accepted
Andy Heinzer
Atlassian Team
Atlassian Team members are employees working across the company in a wide variety of roles.
Apr 05, 2019

Hi everyone,
In an effort to help other users that find this question in search results, I hope this answer better explains the possible solutions here.

While Jira cannot natively return this data directly via JQL in the issue navigator page, there are a few different possible solutions

1) You could run the JQL query for each assignee, then export that data to CSV, and then use a sum function in a program like Excel or Google Sheets to find this info. Admittedly this method is slow, and tedious, especially if you need to do this for several assignees.

2) You could use a pie chart gadget in Jira to try to visualize data. Tomas Vrabec posted a solution on how he did this:

Hi there,

founded built-in solution.

Its a workaround, but its working.

1) Create JQL filter returning issues you would like to sum

2) Create dashboard

3) Add "Workload Pie Chart" Gadget

4) Set it for that created filter & estimations you would like to see.

Works for me.


Snímek obrazovky 2017-08-14 v 14.06.30.png


3) A third party plugin to Jira could help here. For example, Scriptrunner does have an aggregateexpression that can be used here to sum values like this and return them in the JQL results. has more details, however I think you could use an expression like

sprint="21" and assignee="username1" and issueFunction in aggregateExpression("Total Estimate for all Issues", "originalEstimate.sum()", "Remaining work", "remainingEstimate.sum()")

this would show all the issues in that sprint assigned to that user and then give a sum of the original estimates and the sum of the remaining estimates.

Although I've shown scriptrunner can help here, I'm sure there are other possible solutions for this same kind of problem provided by other plugin vendors on Marketplace as well

I hope this helps.


In 2, it's not possible to pick story points as a "Time field to report on". :-/

Like # people like this
0 votes
Answer accepted
Atlassian Team
Atlassian Team members are employees working across the company in a wide variety of roles.
Dec 21, 2017

Hi Chris,

JQL does not currently have a SUM function.  In order to sum totals you would need to utilize an add-on such as ScriptRunner.

Take a look at the Communities post titled Calculate sum of values and Sum of original estimate in issues by filter for more information and suggestion by users of the ScriptRunner add-on.



Thank you for replying Branden.  I've noted what you said. 


2 votes
Piotr Bojko
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 Leaders.
Apr 26, 2018

Using this addon you can use SQL like language and have your report sthg like this

FROM TABLE('Assignee, StoryPoints', JQL('sprint="21" and "Story Points" > 0 and resolution="done"olution="done"')) JQ
GROUP BY JQ.Assignee
1 vote
Aron Gombas _Midori_
Community Leader
Community Leader
Community Leaders are connectors, ambassadors, and mentors. On the online community, they serve as thought leaders, product experts, and moderators.
Apr 17, 2021

You can calculate this and similar aggregations with the Better Excel Exporter app.

The use case is mentioned is among the app's sample exports:


Hi. I found this thread while looking for a way to sum story points. 
I have now creates several filters. e.g. 

resolved >= -2w AND "Agile Team" = "Data Warehouse" AND type in (Story, Bug) AND issueFunction in aggregateExpression(Effort, "effort.sum()")
resolved >= -2w AND "Agile Team" = "{temp name}" AND type in (Story, Bug) AND issueFunction in aggregateExpression(Effort, "effort.sum()") 

basically a filter for each team. I would not like to represent this in a nice way.. like in one gadget or something. 

! We are using Kanban so no sprints

Deleted user May 31, 2021

Hey @Kristian Lind I am trying to do the same for my project and this is my JQL query - project = Support AND createdDate >= startOfWeek() AND Organizations = "ABC" AND (Organizations, "organizations.sum()")

Can you please advise if I am doing it wrong as this doesn't seem to work?

0 votes
Marlene Kegel - codefortynine
Marketplace Partner
Marketplace Partners provide apps and integrations available on the Atlassian Marketplace that extend the power of Atlassian products.
Jul 25, 2023


I am Marlene from codefortynine.

Another option to sum-up story points would be our app Quick Filters for Jira Dashboards.

With our app you can aggregate any numeric field with the Quick Issue Statistics gadget, the Quick Two Dimensional Filter Statistics gadget and the Pie Chart gadget.


After installation you simply:

  • Navigate to your Jira Dashboard
  • Add one of the gadgets mentioned above
  • Configure the gadget as any Jira standard gadget
  • Select "Story Points" as value shown

You can check out our app without installation on our demo dashboards.

Since I could not find a simple and free solution I wrote a user script, find it here:


The script will automatically create a SUM column at the top of a query filter or stories in an epic or a dashboard gadget, and will sim any numeric column.


You need Greasemonkey or Tampermonkey to install it, some instructions here:

Here is an exampleimage.png

If the filter contains multiple sprints, are you able to sum totals based on sprints?  

@Vasile Tomoiaga - I downloaded Tampermonkey, installed the user script but I can't get it work. 

Any suggestions please.

The "Sprint Health Gadget" that can be added to a dashboard adds the story points, provides a stat % for time elapsed, work complete and scope change for the current sprint. 

Thanks for this

Suggest an answer

Log in or Sign up to answer
AUG Leaders

Atlassian Community Events