ReferenceSQL ReferenceAggregate Functions

sequenceCount

Counts the number of non-overlapping chains of events, ordered by the timestamp argument, that match the given pattern.

Counts the number of non-overlapping chains of events, ordered by the timestamp argument, that match the given pattern.

row_number

Numbers the current row within its partition starting from 1.

sequenceMatch

Checks whether the sequence of events, ordered by the timestamp argument, contains a chain of events matching the given pattern.