Get product advice from experts

Ask a question →

Join a community group

Find a group →

Advance your career with learning paths

Take a free class →

Earn badges and rewards

Connect and share ideas at events

See the calendar →

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

Suggest an answer

Log in or Sign up to answer

0 votes

Hi @kanishk Tandon

What is the field US defined as?

You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.

Comment

Reply

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.

You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.

Comment

Like

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.

You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.

Comment

Like

No Problem Tom and thanks for your response.

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

You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.

Comment

Like

Was this helpful?

Thanks!

TAGS