Aggregation¶
Summaries for collections.
Functions¶
LENGTH(x)/COUNT(x)→ size of strings, lists, or objects;0fornull.SUM(list)→ sum of numbers; errors on non-numeric entries;0when list is empty.AVG(list)→ average ornullwhen empty; errors on non-numeric entries.MIN(list)/MAX(list)→ smallest/largest value ornullwhen empty; errors on incomparable values.