You can easily get the average of values in a table in RethinkDB:<\/p>\n
r.db('test')\n .table('salaries')\n .avg('salary')\n<\/pre>\nIf you want to do a GROUP BY as well, you’ll need to do a little more effort:<\/p>\n
\nr.db('test')\n .table('salaries')\n .group('role')\n .avg('salary')\n .ungroup()\n .map(\n {Title: r.row('group'), \n Amount: r.row('reduction')})\n<\/pre>\n<\/pre>\n <\/p>\n
| \n \n group<\/div>\n<\/div>\n<\/td>\n \n | \n reduction<\/div>\n<\/div>\n<\/td>\n<\/tr>\n \n | 1<\/div>\n<\/td>\n \n | \n null<\/div>\n<\/div>\n<\/td>\n \n | \n 80600<\/div>\n<\/div>\n<\/td>\n<\/tr>\n \n | 2<\/div>\n<\/td>\n \n | \n Designer<\/div>\n<\/div>\n<\/td>\n \n | \n 72333.33333333333<\/div>\n<\/div>\n<\/td>\n<\/tr>\n \n | 3<\/div>\n<\/td>\n \n | \n Manager<\/div>\n<\/div>\n<\/td>\n \n | \n 106250<\/div>\n<\/div>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n","protected":false},"excerpt":{"rendered":" You can easily get the average of values in a table in RethinkDB: r.db(‘test’) .table(‘salaries’) .avg(‘salary’) If you want to do a GROUP BY as well, you’ll need to do a little more effort: r.db(‘test’) .table(‘salaries’) .group(‘role’) .avg(‘salary’) .ungroup() .map( {Title: r.row(‘group’), Amount: r.row(‘reduction’)}) group reduction 1 null 80600 2 Designer 72333.33333333333 3 Manager … <\/p>\n |