Statistics Query Functions

LogScale's statistics functions provide minimum, maximum, range and other statistical calculations on event data.

Table: Statistics Query Functions

FunctionDefault ArgumentAvailabilityDescription
avg([as], field)field  Calculates the average for a field of a set of events.
count([as], [distinct], [field])field  Counts given events.
max([as], field, [type])field  Finds the largest number for the specified field over a set of events.
min([as], field, [type])field  Finds the smallest number for the specified field over a set of events.
percentile([accuracy], [as], field, [percentiles])field  Finds one event with a field for each percentile specified.
range([as], field)field  Finds numeric range between smallest and largest numbers for field over a set of events.
sample([field], [percentage])percentage  Samples the event stream.
session([function], [maxpause])function  Collects events into sessions, and aggregates them.
stats([function])function  Used to compute multiple aggregate functions over the input.
stdDev([as], field)field  Calculates the standard deviation for a field over a set of events.