statsby

Type of operation: Aggregate

Description

Calculate statistics of columns with aggregate functions, based on (optional) grouping columns. If you want a accelerable version, consider timestats or timechart.

Usage

statsby [ groupby ] ..., groupOrAggregateFunction ...

Argument

Type

Required

Multiple

groupby

fieldref

Optional

Can be multiple

groupOrAggregateFunction

expression

Required

Can be multiple

Accelerable

statsby is never accelerable. A dataset that only uses accelerable verbs, can be accelerated, making queries on the dataset respond faster.

Examples

statsby Count:count(1), group_by(server_name)

Group input data by server name, calculating a count of rows per server name, returning a dataset with the two columns server_name and Count.