average
Gets double values for row values of the column and calculates the average value of those values.
Returns empty if there is no valid rows
Syntax
average(columnName)
Arguments
columnName: Is the name of a column in the data table.
Return type
number or empty
Examples
//get the average score of all students
number a = average(Score) where (true);
Availability
Version 4.8