sum

Aggregate Function

  sum — sum of input values

Synopsis

sum(number) -> number

Description

The sum aggregate function computes the mathematical sum of its input.

Examples

Sum of simple sequence:

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

=>

10

Continuous sum of simple sequence:

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

=>

1
3
6
10

Unrecognized types are ignored:

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

=>

10

Sum of values bucketed by key:

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

=>

{k:1,sum:3}
{k:2,sum:7}