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; } } }

JQL to get the sum of total Story points in a project

Bhushan Naga [ CONT-Type1-THUNDERSOFT INDIA PRIVAT

Hi Team,
Please help me with sum of total story points in a project in jira cloud.
Previously I used the below expression when scriptrunner was available and I have Scriptrunner Enhanced Search now.
issueFunction in aggregateExpression("Total Points", "storypoints.sum()")

Appreciate your help!!!

Thanks

Accepted answers

John Funk

Hi Bhushan,

Take a look at this article and see if it helps you. You can roll those amounts up to a parent work item such as an Epic.

All comments

Evgenii

Hi, @Bhushan Naga [ CONT-Type1-THUNDERSOFT INDIA PRIVATE LIMITED ]

JQL is designed to work with issues and returns a list of issues as results. Field values are used only to filter and narrow down the query — to make it more specific.

This means that JQL won't return just a number of Story Points directly. However, you can create a query to find all issues in a project that have Story Points assigned, and then manually or via a gadget/dashboard, sum them up. Example of JQL:

project = TEST AND "Story Points" IS NOT EMPTY

Duc Thang TRAN

Hello @Bhushan Naga [ CONT-Type1-THUNDERSOFT INDIA PRIVATE LIMITED ]

I often used ScriptRunner on Data Center with math expressions. However, in ScriptRunner Cloud, I don't see that option available in Scriptrunner Enhanced Search.
So I believe it's not possible to calculate the sum directly via JQL, since math expressions aren't supported on cloud
An alternative might be to export via Excel for Jira Cloud, with colum, 'Story Points' column and perform the calculation in Excel.

Hope this can help

John Funk

Hi Bhushan,

Take a look at this article and see if it helps you. You can roll those amounts up to a parent work item such as an Epic.

Bhushan Naga [ CONT-Type1-THUNDERSOFT INDIA PRIVAT

Hi @John Funk

Can I have the article link

John Funk

DOH! Forgot to add that. Sorry.

https://community.atlassian.com/t5/Jira-articles/How-Can-I-Sum-Up-Multiple-Issues-into-a-Parent-Number-Field/ba-p/2882712

Welcome!

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

Quick Links

Find more posts tagged with

jira

cloud

jira-cloud