OPAL Aggregate Verbs

Aggregate verbs establish an aggregate context: multiple input rows generate fewer, summarizing, output rows.

Verb	Description
aggregate	Aggregates metrics across tag dimensions.
align	Align raw metrics onto a time grid (defined by the input period) by aggregating nearby data points together.
dedup	dedup collapses all rows in a dataset with the same timestamp and identical values in specified columns to one row.
fill	Fills all the missing data in the query window or fills the missing data ahead of the last bucket by the given frame.
histogram	Generate an approximated equi-width histogram for the selected expression.
make_session	Group events or intervals that are close to each other into sessions, and calculate aggregations over each session.
merge_events	Merge consecutive events into new events based on merge conditions.
pivot	The pivot verb rotates a table by transforming rows into columns.
rollup	Rollup raw metrics into aligned metrics.
statsby	Calculate statistics of columns with aggregate functions, based on (optional) grouping columns.
timechart	Bin (in time) and aggregate point or interval table columns through time, based on (optional) grouping columns.
timestats	Aggregate columns at every point in time, based on (optional) grouping columns.
unpivot	The unpivot verb rotates a table by transforming a list of columns into rows.