Skip to main content
interface AggregateStatisticsByRangeRequest
column_name: string;
end: number;
interval: number;
options?: Record<string, string>;
select_expression?: string;
start: number;
stats: string;
table_name: string;
value_column_name: string;
column_name end interval options? select_expression? start stats table_name value_column_name
column_name: string

Name of the binning-column used to divide the set samples into bins.

end: number

The upper bound of the binning-column.

interval: number

The interval of a bin. Set members fall into bin i if the binning-column falls in the range [start+intervali, start+interval(i+1)).

options?: Record<string, string>

Optional parameters.

select_expression?: string

For a non-empty expression statistics are calculated for those records for which the expression is true.

start: number

The lower bound of the binning-column.

stats: string

A string of comma separated list of the statistics to calculate, e.g. ‘sum,mean’. Available statistics: mean, stdv (standard deviation), variance, skew, kurtosis, sum.

table_name: string

Name of the table on which the ranged-statistics operation will be performed, in [schema_name.]table_name format, using standard name resolution rules.

value_column_name: string

Name of the value-column for which statistics are to be computed.