avg

ReQL command: avg

Command syntax

sequence.avg([field | function]) → number
r.avg(sequence, [field | function]) → number

Description

Averages all the elements of a sequence. If called with a field name, averages all the values of that field in the sequence, skipping elements of the sequence that lack that field. If called with a function, calls that function on every element of the sequence and averages the results, skipping elements of the sequence where that function returns nil or a non-existence error.

Produces a non-existence error when called on an empty sequence. You can handle this case with default.

Example: What’s the average of 3, 5, and 7?

r([3, 5, 7]).avg().run(conn)

Example:登录查看完整内容