jjzjj

dataDate

全部标签

Mongodb 聚合框架 : Sum values for max date in month

我每周从服务中接收数据并将其放入集合中。数据有数量、projectNo和dataDate时间戳。使用聚合框架,我按projectNo和dataDate对数量和分组进行求和:db.collection.aggregate([{$project:{projectNo:1,bdgtAppd:1,dataDate:1}},{$group:{_id:{projectNo:"$projectNo",dataDate:"$dataDate"},amount:{$sum:"$bdgtAppd"}}},{$project:{_id:0,projectNo:"$_id.projectNo",dataDat