Statistics Query Functions
LogScale's statistics functions provide minimum, maximum, range and other statistical calculations on event data.
Table: Statistics Query Functions
| Function | Default Argument | Availability | Description |
|---|---|---|---|
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) | field | Â | Finds the largest number for the specified field over a set of events. |
min([as], field) | 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. |