AVERAGE
Calculates the average of the values in the source columns and returns the result in a new column. Any non-number is ignored.
Parameters
-
sourceColumns
– A JSON-encoded string representing a list of existing columns. -
targetColumn
– A name for the newly created column.
Example
{ "RecipeAction": { "Operation": "AVERAGE", "Parameters": { "sourceColumns": "[\"age\",\"weight_kg\",\"height_cm\"]", "targetColumn": "AVERAGE Column 1" } } }