Need average of integer custom field

Question

Hello All,

My requirement is as below:

We have a custom field in ticket/issue screen of 'Integer' type and we need to generate average of all tickets on project level.

Example:

Ticket 1: 3.5

Ticket 2: 4

Ticket 3: 2

Ticket 4: 4.5

Average of field on project level: 3.5

Any guidance on how to generate this would be really helpful.

--

Regards,

Sumit

Michelle Gaul · Answer

@Sumit Jain i'm sorry if i'm bothering you because i don't have ananswer to your question.

You said that you have a custom field of the integer type. When I want to add a numeric custom field I only have the option to add one of the "double" type, which means every number is returned with ".0", eg. 10 is 10.0 .

How did you add an integer custom field?

thanks in advance for your answer!

Kian Stack Mumo Systems · Answer

I don't know if Sumit is using server or cloud. At the moment Abacus is only availible for cloud, but we will be releasing a server version quite soon.

Petter Gonçalves · Answer

Hello Sumit,

JIRA itself does not have a functionality to calculate the average number of a specific custom field in multiple issues, however, there are some alternatives to achieve it:

1 - Export your issues to CSV (Excel)

You can export your issues to a CSV file and use a third-party application (Excel, LibreOffice, etc) to create a simple formula to calculate the average of your number custom fields.

2 - Use a Third-party plugin

There are some add-ons where you could calculate the average of a specific number field on a list of issues and add the value to a linked Epic/issue field:

- Abacus - JIRA Calculator

- Excel Connector for JIRA

Let me know if one of these options helps you, Sumit.