avg

Aggregate Function

  avg — average value

Synopsis

avg(number) -> number

Description

The avg aggregate function computes the mathematical average value of its input.

Examples

Average value of simple sequence:

echo '1 2 3 4' | zq -z 'avg(this)' -

=>

2.5

Continuous average of simple sequence:

echo '1 2 3 4' | zq -z 'yield avg(this)' -

=>

1.
1.5
2.
2.5

Unrecognized types are ignored:

echo '1 2 3 4 "foo"' | zq -z 'avg(this)' -

=>

2.5

Average of values bucketed by key:

echo '{a:1,k:1} {a:2,k:1} {a:3,k:2} {a:4,k:2}' |
  zq -z 'avg(a) by k | sort' -

=>

{k:1,avg:1.5}
{k:2,avg:3.5}