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 next
d-excerpt

Aggregate functions perform a computation against a set of values to generate a single result. For example, you could use an aggregate function to compute the average (mean) order over a period of time. Aggregations can be applied as standard functions or used as part of a transformation step to reshape the data.

Aggregate across an entire column:

D trans
RawWrangletrue
Typestep
WrangleTextderive type:single value:average(Scores)
p01NameFormula type
p01ValueSingle row formula
p02NameFormula
p02Valueaverage(Scores)
SearchTermNew formula

...

A pivot transformation can include multiple aggregate functions and group columns from the pre-aggregate dataset. For more information on the transformation, see Pivot DataSee Pivot Transform.

Info

NOTE: Null values are ignored as inputs to these functions.

...