Calculates the average for a field over a set of events. The result is returned in a field named _avg. You can use this field name to pipe the results to other query functions for further processing, as shown in the example below.
Hide omitted argument names for this function
Omitted Argument NamesThe argument name for
field
can be omitted; the following forms of this function are equivalent:logscaleavg("field")
and:
logscaleavg(field="field")
These examples show basic structure only.
avg()
Examples
As an example of how you might use the avg()
query
function, suppose you have a repository with events that include
receiving occasionally small files. Suppose further that you want to
determine the average size of files received into the repository. To do
this, you might use a query such as this:
avg(field=cputime)
| format("%,.2f", field=_avg, as=_avg)
The query averages the values of the
cputime fields in events. The
average of those values is determined using the
avg()
function. That number is then piped to the
format()
function, which formats the number to two
decimal places, using ,
as the thousands separtor.
The query would return this result:
275 | 901.03 |
In the example above, the result is presented using the
Single Value
widget.