Skip to main content

Group or Aggregate Operators

In this section, we'll introduce the following concepts:

icon

avg

Calculates the avg value of a numerical field being evaluated.

icon

count, count_distinct, count_frequent

Use with a group operator and field name.

icon

first, last

Return the first or last result relative to the sort order.

icon

median

Calculates the median value for a particular field.

icon

min, max

Use these functions to find the smallest or largest value in a set of values.

icon

most_recent, least_recent

Select the most or least recent value within a group.

icon

pct

Finds the specified percentiles of a given field.

icon

pct_sampling

Finds the percentile of a given field.

icon

stddev

Finds the standard deviation for numerical values within a time range.

icon

sum

Adds values of a numerical field being evaluated within a time range.

icon

values

Provides all the distinct values of a field.


Status
Legal
Privacy Statement
Terms of Use

Copyright © 2024 by Sumo Logic, Inc.