commit 2495cc8ae5cf0b32bcf1d37b38686ec2479becc6
author Avery Pennarun <apenwarr@gmail.com> Sat Dec 22 05:07:42 2012 -0500
committer Avery Pennarun <apenwarr@gmail.com> Sat Dec 22 05:07:42 2012 -0500
tree d7e6b85afcaf20fa43e9414a9493cad271bc7d72
parent fa1ff70844360b087807aae62a9d5612e63accdf

Add the avg() aggregate function.

Don't know how I missed that one.

render.js

diff --git a/render.js b/render.js
index b12e874..d94b4ab 100644
--- a/render.js
+++ b/render.js
@@ -378,6 +378,10 @@
       return acc;
     },
 
+    avg: function(l) {
+      return agg_funcs.sum(l) / agg_funcs.count_nz(l);
+    },
+
     color: function(l) {
       for (var i in l) {
         var v = l[i];
@@ -392,6 +396,7 @@
   agg_funcs.count_nz.return_type = T_NUM;
   agg_funcs.count_distinct.return_type = T_NUM;
   agg_funcs.sum.return_type = T_NUM;
+  agg_funcs.avg.return_type = T_NUM;
   agg_funcs.cat.return_type = T_STRING;
   agg_funcs.color.return_type = T_NUM;