## Key

• This line was added.
• This line was removed.
• Formatting was changed.
Comment: Published by Scroll Versions from space DEV and version r0811

D toc

Excerpt

Computes the average of all numeric values found in input array. Input can be an array literal, a column of arrays, or a function returning an array. Input values must be of Integer or Decimal type.

When this function is invoked, all of the values in the input array are passed to the corresponding columnar function. Some restrictions may apply. See AVERAGE Function.

D s lang vs sql

D s
snippet Basic

Literal example:

D lang syntax
RawWrangle true ref true derive type:single value:listaverage([0,0,2,4,6,8,10,12,14,16,18,20]) as:'myArrayAvg'

listaverage([0,0,2,4,6,8,10,12,14,16,18,20])

Output: Returns the average of all values in the literal array: `19.1667`.

Column example:

D lang syntax
RawWrangle true ref true derive type:single value:listaverage(myArray) as:'myArrayAvg'

listaverage(myArray)

Output: Returns the average of all values in the arrays of the `myArray` column.

D s
snippet Syntax

D lang syntax
RawWrangle true syntax true derive type:single value:listaverage(array_ref)

listaverage(array_ref)

ArgumentRequired?Data TypeDescription
array_refYArrayArray literal, reference to column containing arrays, or function returning an array

D s lang notes

### array_ref

Reference to an array can be an array literal, function returning an array, or a single column containing arrays.

• If the input is not a valid numeric array, null values are returned.
• Non-numerical values within an input array are not factored in the computation.
• Multiple columns and wildcards are not supported.

D s
snippet usage

Required?Data TypeExample Value
Yes

Array

`myArray`

D s
snippet Examples

### Example - Math functions for lists (arrays)

Include Page
 EXAMPLE - LIST Math Functions EXAMPLE - LIST Math Functions

D s also
label nested