Skip to content

rollup()

Combine multiple TimeWeightSummaries

Since 1.0.0

Combine multiple intermediate time-weighted aggregate (TimeWeightSummary) objects produced by time_weight() into a single intermediate TimeWeightSummary object. For example, you can use rollup to combine time-weighted aggregates from 15-minute buckets into daily buckets.

The syntax is:

rollup(
tws TimeWeightSummary
) RETURNS TimeWeightSummary
NameTypeDefaultRequiredDescription
time_weightTimeWeightSummary-The TimeWeightSummary aggregate produced by a time_weight call
ColumnTypeDescription
rollupTimeWeightSummaryA new TimeWeightSummary aggregate produced by combining the input TimeWeightSummary aggregates