Page tree

Versions Compared

Key

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

...

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

D s
snippetBasic

Literal example:

LISTAVERAGE
d-code-lang-syntax
RawWrangletrue
Typeref
showNotetrue
WrangleTextderive 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: Generates an output column containing  Returns the average of all values in the literal array: 19.1667.

Column example:


LISTAVERAGE
d-code-lang-syntax
RawWrangletrue
Typeref
showNotetrue
WrangleTextderive 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
snippetSyntax

LISTAVERAGE
d-code-lang-syntax
RawWrangletrue
Typesyntax
showNotetrue
WrangleTextderive 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

...