Can't Aggregate Custom Fields

[Luis Laurenzo Dapat]

Hello,

I'm trying to aggregate custom fields in JIRA, but I don't see any summation showing up. the JQL I'm using is shown below.

project = "Tech" and issuetype = "Project" and issueFunction in aggregateExpression("Total Cost","customfield_10201.sum()")

I'm writing this in the search bar of Jira where filtering is usually done. Am I not writing it correctly, or should I be writing this in a different place aside from the search?

[Nic Brough -Adaptavist- · Accepted solution]

JQL finds issues to report on.  What are you using to try to do reporting that includes adding up fields?

[Luis Laurenzo Dapat]

Hi Nic,

My main goal is to add one gadget to the dashboard that would show the total cost of all issues per status. 

[Nic Brough -Adaptavist-]

I'm not aware of any gadget that adds up numbers!  Other than the dedicated ones that look at things like story points, estimates and work-logs.

The function you've found in ScriptRunner does not give you a field or anything you can use in a gadget, it just returns the calculation in a box.

[Luis Laurenzo Dapat]

Hi Nic,

Thanks for clarifying. If that's the case, then I might look for an app/add-on that just does this for me.

Thank you for your help!

[Antoine Berry · Accepted solution]

Hi @Luis Laurenzo Dapat , welcome to the community.

This JQL looks fine. What error did you get ?

[Luis Laurenzo Dapat]

Hi Antoine,

I'm not getting an error. However, I'm not getting the results I'm looking for. I was expecting that through that JQL, I would see some sort of summary that would show the total cost. I got the info from this link: https://jamieechlin.atlassian.net/wiki/spaces/GRV/pages/33030163/Scripted+JQL+Functions#ScriptedJQLFunctions-AggregateExpressions. 

[Antoine Berry]

Exactly, this has been working fine for me. Is your custom field a number field ?

[Luis Laurenzo Dapat]

Yes, it's a number field. 

[Luis Laurenzo Dapat]

Hi Antoine,

It turns out that it does work. I just have to refresh the page after I click search. I don't know why it's this way.

Thank you for your help!