Aggregation Operators

Aggregation operators help aggregate log messages into groups. FuseQL supports the following aggregation operators:

count all log lines or fingerprints.
count_unique of labels or string-valued facets.
statistical operations (min, max, avg, sum, stddev, stdvar and percentiles) on numeric or duration facet values.
misc aggregation operations (first and last).

Facet values have duration datatype if they follow go duration format. While applying any aggregation operators on these values, they are normalized to nanosecond float value.

All aggregations are performed after applying filters, if any, in the log search bar, and in a time range selected by the user in the time picker. All aggregations are grouped by time buckets, unless user specifies additional grouping from the by dropdown.

count

Counts the total number of log lines.

count_unique

Counts only unique or distinct occurrences of the field. This operator can be applied on fingerprints, labels or string valued facets (facet value can be of string/UUID/IP address datatype).