DSAVG
Averages column values in the given Data Source, optionally filtering rows by formula.
Syntax
DSAVG(dsId, columnIndex, 'optionalFilterFormula')
Example
DSAVG('STAFF', 2) averages the 3rd column's values
Add a filter formula using {{this[column]}} to refer to columns.
DSAVG('STAFF', 2, '{{this[5]}} = "BOB"') averages 3rd column where 6th column = BOBNotes
Refer to the Data Source by its External Id (from the Data Source -> Settings page).
Refer to the column by its zero-based index.