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: 

Multiple aggregate expressions on same field in JQL

PaulDaPigeon
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!
September 26, 2022

I currently have a few similar filters where I use aggregate expressions. The queries for the are the same except the label E.g.:

Screen Shot 2022-09-26 at 18.55.56.pngScreen Shot 2022-09-26 at 18.59.31.png

I'd like to move to a setup where I have 1 query, and I get all the different summed story points for backend, frontend and other on 1 page.

I've tried combining the queries but I only get the last sum.

Screen Shot 2022-09-26 at 19.02.32.png

Is there are any way to achieve this?

1 answer

Comments for this post are closed

Community moderators have prevented the ability to post new answers.

0 votes
Trudy P Claspill
Community Champion
September 26, 2022

Hello @PaulDaPigeon 

Welcome to the community.

Based on the documentation for the function it is used to return values for all issues in the filter. It doesn't appear that you can use it multiple times against portions of the filter.

https://scriptrunner.adaptavist.com/latest/jira/jql-functions.html#_aggregateexpression