All standard aggregate functions and available modifiers are listed on this page.
An aggregate function call contains an expression in curly braces ("{}"), which is calculated for the item and all sub-items (or, in some cases, for another subset of related items in the structure), and then the resulting values are aggregated according to the meaning of the aggregate function.
Produces an array of the defined values for the item and/or its sub-items. Accepts modifiers: .Aggregate Function Reference v9.2##ancestors, .Aggregate Function Reference v9.2##children, .Aggregate Function Reference v9.2##leaves, .Aggregate Function Reference v9.2##strict, .Aggregate Function Reference v9.2##subtree, .Aggregate Function Reference v9.2##fromLevel, .Aggregate Function Reference v9.2##toLevel, .Aggregate Function Reference v9.2##reverse, .Aggregate Function Reference v9.2##distinct (does not include duplicate values), .Aggregate Function Reference v9.2##flatten (if function produces an array, includes the inner values, rather than the array), .Aggregate Function Reference v9.2##compact |
Avg calculates an average of the defined values for the item and/or its sub-items. The result for avg is generally the same as sum/count. It returns nothing if there are no defined values for {x}.
Accepts modifiers: .Aggregate Function Reference v9.2##all, .Aggregate Function Reference v9.2##children, .Aggregate Function Reference v9.2##leaves, .Aggregate Function Reference v9.2##strict, .Aggregate Function Reference v9.2##subtree, .Aggregate Function Reference v9.2##preceding, .Aggregate Function Reference v9.2##levels (together with #preceding), .Aggregate Function Reference v9.2##baseLevel (together with #preceding). |
Count calculates a count of defined values (or truthy values, if the #truthy modifier is specified) for the item and/or its sub-items.
Accepts modifiers: .Aggregate Function Reference v9.2##all, .Aggregate Function Reference v9.2##children, .Aggregate Function Reference v9.2##leaves, #level, .Aggregate Function Reference v9.2##strict, .Aggregate Function Reference v9.2##subtree, .Aggregate Function Reference v9.2##truthy, .Aggregate Function Reference v9.2##preceding, .Aggregate Function Reference v9.2##levels (together with #preceding), .Aggregate Function Reference v9.2##baseLevel (together with #preceding). |
Returns true if the current row is an issue and it matches this JQL.
|
Max returns the maximum defined value for the item and/or its sub-items. Numeric, date, duration and text fields can be compared. Text fields are compared lexicographically. If the formula produces an array, this will find the maximum element within that array. Accepts modifiers: .Aggregate Function Reference v9.2##children, .Aggregate Function Reference v9.2##leaves, .Aggregate Function Reference v9.2##strict, .Aggregate Function Reference v9.2##subtree. |
Produces the median value. Works the same as .Aggregate Function Reference v9.2#PERCENTILE#0.5. Undefined are ignored. Non-number values result in an error. Accepts modifiers: .Aggregate Function Reference v9.2##ancestors, .Aggregate Function Reference v9.2##children, .Aggregate Function Reference v9.2##leaves, .Aggregate Function Reference v9.2##strict, .Aggregate Function Reference v9.2##subtree, .Aggregate Function Reference v9.2##fromLevel, .Aggregate Function Reference v9.2##toLevel |
Min returns the minimum defined value for the item and/or its sub-items. Numeric, date, duration and text fields can be compared. Text fields are compared lexicographically. If the formula produces an array, this will find the minimum element within that array. Accepts modifiers: .Aggregate Function Reference v9.2##children, .Aggregate Function Reference v9.2##leaves, .Aggregate Function Reference v9.2##strict, .Aggregate Function Reference v9.2##subtree. |
Parent extracts the value from the parent row or from an ancestor row by a specified level. Using the #level modifier, you can specify which row to extract the value from:
Accepts modifier: .Aggregate Function Reference v9.2##level. |
Calculates a percentile value from the defined values for the item and/or its sub-items. The hierarchy of values is ignored – all subject values are treated equally. Must include the modifier #p, followed by the desired percentile (p=0.95, p=95). p=1 interpreted as 1%. Undefined are ignored. Non-number values result in an error. Accepts modifiers: .Aggregate Function Reference v9.2##ancestors, .Aggregate Function Reference v9.2##children, .Aggregate Function Reference v9.2##leaves, .Aggregate Function Reference v9.2##strict, .Aggregate Function Reference v9.2##subtree, .Aggregate Function Reference v9.2##fromLevel, .Aggregate Function Reference v9.2##toLevel, #p (required) |
Works the same as .Aggregate Function Reference v9.2#PERCENTILE#0.25. Undefined are ignored. Non-number values result in an error. Accepts modifiers: .Aggregate Function Reference v9.2##ancestors, .Aggregate Function Reference v9.2##children, .Aggregate Function Reference v9.2##leaves, .Aggregate Function Reference v9.2##strict, .Aggregate Function Reference v9.2##subtree, .Aggregate Function Reference v9.2##fromLevel, .Aggregate Function Reference v9.2##toLevel |
Works the same as .Aggregate Function Reference v9.2#PERCENTILE#0.75. Undefined are ignored. Non-number values result in an error. Accepts modifiers: .Aggregate Function Reference v9.2##ancestors, .Aggregate Function Reference v9.2##children, .Aggregate Function Reference v9.2##leaves, .Aggregate Function Reference v9.2##strict, .Aggregate Function Reference v9.2##subtree, .Aggregate Function Reference v9.2##fromLevel, .Aggregate Function Reference v9.2##toLevel |
Sum calculates a numerical total for the values calculated for the item and/or its sub-items. Other variations of
Note that when the value of the expression under aggregation is not numeric (and cannot be converted to a number), it is ignored.
Accepts modifiers: .Aggregate Function Reference v9.2##all, .Aggregate Function Reference v9.2##children, Aggregate Function Reference##leaves, #level, #level, .Aggregate Function Reference v9.2##preceding, .Aggregate Function Reference v9.2##strict, .Aggregate Function Reference v9.2##subtree, .Aggregate Function Reference v9.2##levels (together with #preceding), .Aggregate Function Reference v9.2##baseLevel (together with #preceding). |
Produces an array of all distinct values for the item and/or its sub-items. If a value is an array, considers each value in the array separately. Accepts modifiers: .Aggregate Function Reference v9.2##ancestors, .Aggregate Function Reference v9.2##children, .Aggregate Function Reference v9.2##leaves, .Aggregate Function Reference v9.2##strict, .Aggregate Function Reference v9.2##subtree, .Aggregate Function Reference v9.2##fromLevel, .Aggregate Function Reference v9.2##toLevel |
Defines the exit separator between children and parent rows. This modifier has a string parameter. The default exit separator is:
Can be used with: join. |
Tells the aggregate function to include duplicate items. By defaults, functions that count values ignore duplicate items.
|
Only process ancestors of the current row. This is the default behavior for join. Can be used with: array, join, median, percentile, quartile1, quartile3, values. |
Can be used with .Aggregate Function Reference v9.2#SUM with the
Can be used with: avg, count, sum (together with #preceding). |
Only process direct children of the current row.
Can be used with: array, sum, count, avg, join, min, max, median, percentile, quartile1, quartile3, values. |
Ignores undefined values when collecting an array. This modifier is implicitly turned on by applying the .Aggregate Function Reference v9.2##distinct modifier to the join aggregate function. Can be used with: array. |
Same as .Aggregate Function Reference v9.2##level modifier, except #depth cannot be used with SUM, COUNT, or AVG. |
#distinct with ARRAY Makes array only produce an array of distinct values. A duplicate value won't be added more than once if this modifier is on.
#distinct with JOIN Makes join only concatenate distinct values. A duplicate value won't be added more than once if this modifier is on. When used with arrays, removes undefined values and performs one-step flattening. Modifiers .Aggregate Function Reference v9.2##beforeChildren and .Aggregate Function Reference v9.2##afterChildren don't work when this option is on.
Can be used with: join. |
When collecting values from sub-items (or another subset of related items) if a value is an array, includes all the elements instead of just including the array. This modifier is implicitly turned on by applying the .Aggregate Function Reference v9.2##distinct modifier to the join aggregate function. Can be used with: array. |
Same as .Aggregate Function Reference v9.2##fromLevel, except #fromDepth cannot be used with MEDIAN, PERCENTILE, QUARTILE1, or QUARTILE3. |
Specifies the position of the first row the aggregate function should take as input for a sequence. Position is specified by an integer parameter denoted as n below:
This modifier does not work with any tree types except .Aggregate Function Reference v9.2##ancestors.
Can be used with: array, join, median, percentile, quartile1, quartile3, values. |
Only process leaves (items without children) in the subtree of the current row.
Can be used with: array, sum, count, avg, join, min, max, median, percentile, quartile1, quartile3, values. |
When used with .Aggregate Function Reference v9.2#PARENT, specifies the position of the parent that possesses value. Position is specified by an integer parameter denoted as n below:
When used with .Aggregate Function Reference v9.2#SUM with the
Can be used with: parent, sum (together with #preceding), count (together with #preceding), avg (together with #preceding). |
Can be used with .Aggregate Function Reference v9.2#SUM with the
Note that if you use the .Aggregate Function Reference v9.2##baseLevel modifier, only values at levels that are deeper than the base level will be counted. You can also use .Aggregate Function Reference v9.2##level instead of #levels. Can be used with: avg, count, sum (together with #preceding). |
Can be used with .Aggregate Function Reference v9.2#SUM to calculate a numeric total of the current item and all items above it in the structure. Can be combined with the following modifiers:
|
Reverses the order of row processing.
|
Defines the separator for string joining. This modifier has a string parameter. The default is ", ".
Can be used with: join. |
Do not process the current row item as part of the aggregation. Cannot be used together with .Aggregate Function Reference v9.2##children, .Aggregate Function Reference v9.2##ancestors or .Aggregate Function Reference v9.2##leaves, since these already exclude the current row.
Can be used with: array, sum, count, avg, join, min, max, median, percentile, quartile1, quartile3, values. |
Process the whole subtree of the current row. This is the default behavior for sum, count, avg, min, max.
Can be used with: array, sum, count, avg, join, min, max, median, percentile, quartile1, quartile3, values. |
Same as .Aggregate Function Reference v9.2##toLevel, except #toDepth cannot be used with MEDIAN, PERCENTILE, QUARTILE1, or QUARTILE3. |
Specifies the position of the last row the aggregate function should take as input for a sequence. Position is specified by an integer parameter denoted as n below:
This modifier does not work with any tree types except .Aggregate Function Reference v9.2##ancestors.
Can be used with: array, join, median, percentile, quartile1, quartile3, values. |
Only count row if the subexpression produces a truthy value .
Can be used with: count. |