Script Runner - AggregateExpression on customfield

Hi there,

we tried to aggregate some numbers via aggregateExpression, but the result is a bit creapy:

image2016-6-16 11:35:38.png2016-06-16 11_32_09-Issue Navigator - JIRA 4 BIZ.jpg

As you can see the CF_10205 is of type number and contains some data, but the result if the aggregation is not useable. Any ideas?

And maybe suitable, are there any gadgets or reports available to add in a JIRA dashboard or Confluence page (beside building an own SQL-Report or EazyBI) to show such kind of aggregations (maybe based on status and/or issue type)?

Many thanks in advance!
Hans-Hermann

1 answer

1 accepted

Accepted Answer
0 votes

Technically, that is still a valid and usable number (most calculation software will accept and process numbers with exponents in them).  The problem here is that it's a very large number that isn't really a lot of use to humans and isn't really that display-able. 

You'll find a lot of other software will display the number in the same way too, so even moving to other reporting tools might not help.

Hi Nic,

thanks for the quick reply!

In summary, you think there is no real solution in case the numbers might get bigger? Tried with numbers in summary > 10k and it´s working...

I'm not sure what "solution" you're looking for - the numbers are too long to display, so most programs will shorten them.

IMHO i expected numbers till 9-10 digits to be shown in "normal" mode as the exponetial ones are also that long. In case we talks about > 15 digits i would agree...

But, now i understand how it works so thanks for clarification!

Best regards,
Hans-Hermann

Suggest an answer

Log in or Sign up to answer
Community showcase
Posted Sep 18, 2018 in Jira

What modern development practices are at the heart of how your team delivers software?

Hey Community mates! Claire here from the Software Product Marketing team. We all know software development changes rapidly, and it's often tough to keep up. But from our research, we've found the h...

24,478 views 2 7
Join discussion

Atlassian User Groups

Connect with like-minded Atlassian users at free events near you!

Find a group

Connect with like-minded Atlassian users at free events near you!

Find my local user group

Unfortunately there are no AUG chapters near you at the moment.

Start an AUG

You're one step closer to meeting fellow Atlassian users at your local meet up. Learn more about AUGs

Groups near you