Getting jql results in the multiple of thausands

kanishk Tandon November 21, 2018

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

Suggest an answer

Log in or Sign up to answer
0 votes
Tom Lister
Community Leader
Community Leader
Community Leaders are connectors, ambassadors, and mentors. On the online community, they serve as thought leaders, product experts, and moderators.
November 21, 2018

Hi @kanishk Tandon

What is the field US defined as?

kanishk Tandon November 22, 2018

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
Community Leader
Community Leaders are connectors, ambassadors, and mentors. On the online community, they serve as thought leaders, product experts, and moderators.
November 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.

kanishk Tandon November 22, 2018

No Problem Tom and thanks for your response.

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

TAGS
AUG Leaders

Atlassian Community Events