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 Table, Event, or Interval dataset with identical values in specified columns and with identical
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 resource 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.