Script Runner - AggregateExpression on customfield

Hans-Hermann Hunfeld

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

2016-06-16 11_32_09-Issue Navigator - JIRA 4 BIZ.jpg

image2016-6-16 11:35:38.png

Nic Brough -Adaptavist-

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.