MV_AVGedit
Converts a multivalued field into a single valued field containing the average of all of the values. For example:
ROW a=[3, 5, 1, 6] | EVAL avg_a = MV_AVG(a)
| a:integer | avg_a:double |
|---|---|
[3, 5, 1, 6] |
3.75 |
The output type is always a double and the input type can be any number.