Page tree

 

Support | BlogContact Us | 844.332.2821

Versions Compared

Key

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

...

D s
snippetBasic
D code

aggregate value:MAX(totalSales) group: Region

Output:  Reshapes the dataset to two columns: The new Region column contains the unique values from the source Region column, and the max_totalSales column contains the maximum value of the values in the original totalSales column for each value in Region.

D s
snippetParameters

D code
aggregate value: AGGREGATE_FUNCTION(column_ref) [group: group_col]

...

Info

NOTE: For the value parameter, you can only use aggregate functions. For more information, see Aggregate Functions .

D s
snippetusage

Required?Data Type
YesString (expression that evaluates to a value using the referenced aggregate function)

group

For the aggregate transform, this parameter specifies the column or columns whose values are used to group the dataset prior to applying the specified function. You can specify multiple column names as comma-separated values.

...

Info

NOTE: Be careful applying this transform across groups containing a large number of unique rows. In some cases, the application can run out of memory generating the results, and your results can fail.

D s
snippetusage

Required?Data Type
NoString (column name)


D s
snippetExamples

See the individual functions for examples. See Aggregate Functions.

...