Come for the products,
stay for the community

The Atlassian Community can help you and your team get more value out of Atlassian products and practices.

Atlassian Community about banner
Community Members
Community Events
Community Groups

Getting jql results in the multiple of thausands

While running the jql query using issueFunction in aggregateExpression("Total points", "US.sum()") I am getting the results in the multiple of thausand like for the result 36, I am getting in Jira as 36000. I am gettig the correct result but with 000 at the end.

Does anyone have an idea for this behaviour.

Thanks in advance.

1 answer

0 votes
Tom Lister Community Leader Nov 21, 2018

Hi @kanishk Tandon

What is the field US defined as?

Sorry I forgot to mention its UserStory, so basically a query to sum up all the User story points of all User Story in an Epic.

Tom Lister Community Leader Nov 22, 2018

Hi Kanishk

Story about lack of response, my MacBook died on me and have been restoring it.

I tried this on my machine and I don't get the 000's error

Screenshot 2018-11-22 at 15.28.48.png

I check my db values for story points and they are just floats with expected value e.g. 5.00000

Nothing else to add I'm afraid.

No Problem Tom and thanks for your response.

Looks like some issue with Jira configuration but the query seems to be correct.

Suggest an answer

Log in or Sign up to answer
Community showcase
Posted in Jira Service Management

Jira Service Management Documentation Opportunities

Hello everyone, Hope everyone is safe! A few months ago we posted an article sharing all the new articles and documentation that we, the AMER Jira Service Management team created. As mentioned ...

285 views 0 6
Join discussion

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