Reporting on numeric custom field

[Luke Campbell]

I have a custom field which is numeric. 

Is there an out-of-box way to report on this field, to show the average of every ticket?

[Trudy Claspill · Accepted solution]

Hello @Luke Campbell 

Welcome to the Atlassian community!

I haven't yet found  an OTB gadget for reporting the average of values for a custom Number field across multiple issues.

You could, however, get this information through an Automation Rule.

You could use the Lookup Issues action  to retrieve the set of issues you want to consider with a JQL statement.

You can get the average of the custom Number field values for that list with this smart value:

{{lookupIssues.<your custom Number field name>.average}}

The "average" function use with lists is documented here.

[Luke Campbell]

This sounds super exciting @Trudy Claspill !

Trying this: 

Project = UT2 and type = Task and 'Time Over Window' > 0 {{lookupIssues.TimeOverWindow.average}}

And Automation won't validate my query; can you see what's wrong?

[Trudy Claspill]

Sorry, I was unclear.

You don't use the smart value in the Lookup Issues action. The Lookup Issues action gives you the ability to use the {{lookupIssues}} smart value/object in other actions.

So, after the Lookup Issues action, you might use a Send Email action and send an email message to somebody. You would use the smart value in the email content.

Also, within the smart value the name of your custom field needs to match what you see as its name in the UI, so it needs to be Time Over Window with spaces rather than TimeOverWindow without spaces.

[Luke Campbell]

Cool! Thanks @Trudy Claspill it works!

Bummer not to be able to report on it .. but nice to have a work around. Thanks again for taking the time. 

[Trudy Claspill]

I'm glad I could help!