Forums

Articles
Create
cancel
Showing results for 
Search instead for 
Did you mean: 

Need average of integer custom field

Sumit Jain
I'm New Here
I'm New Here
Those new to the Atlassian Community have posted less than three times. Give them a warm welcome!
January 28, 2019

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

2 answers

0 votes
Michelle Gaul
Contributor
April 12, 2019

@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!

0 votes
Petter Gonçalves
Atlassian Team
Atlassian Team members are employees working across the company in a wide variety of roles.
January 29, 2019

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

Screen Shot 2019-01-29 at 16.42.51.png

Excel Connector for JIRA

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

Kian Stack Mumo Systems
Community Champion
January 29, 2019

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. 

Suggest an answer

Log in or Sign up to answer
TAGS
atlassian, loom, loom for training, loom for teaching, video training, async learning, online education, screen recording, loom tutorials, loom use cases, atlassian learning, team training tools, instructional video, virtual training tools

🛗 Elevate Your Training and Enablement with Loom

Join us June 26, 11am PT for a webinar with Atlassian Champion Robert Hean & Loom’s Brittany Soinski. Hear tips, stories, and get your burning questions answered. Learn how Loom makes training and enablement easier. Don’t miss it!

Register today
AUG Leaders

Atlassian Community Events