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 an event dataset with identical values in specified columns and with identical timestamp to a single

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.

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