mongodb objetcid,MongoDB $ sum和$ avg子文档

I need to get $sum and $avg of subdocuments, i would like to get $sum and $avg of Channels[0].. and other channels as well.

my data structure looks like this

{

_id : ... Location : 1,

Channels : [

{ _id: ...,

Value: 25

},

{

_id: ... ,

Value: 39

},

{

_id: ..,

Value: 12

}

]

}

解决方案

Solution 1: Using two groups based this example:

previous question

db.records.aggregate(

[

{ $unwind: "$Channels" },

{ $group: {

_id: {

"loc" : "$Location",

"cId" : "$Channels.Id"

},

"value" : {$sum : "$Channels.Value" },

"average" : {$avg : "$Channels.Value"},

"maximun" : {$max : "$Channels.Value"},

"minimum" : {$min : "$Channels.Value"}

}},

{ $group: {

_id : "$_id.loc",

"ChannelsSumary" : { $push :

{ "channelId" : '$_id.cId',

"value" :'$value',

"average" : '$average',

"maximun" : '$maximun',

"minimum" : '$minimum'

}}

}

}

]

)

Solution 2:

there is property i didn't show on my original question that might of help "Channels.Id" independent from "Channels._Id"

db.records.aggregate( [

{

"$unwind" : "$Channels"

},

{

"$group" : {

"_id" : "$Channels.Id",

"documentSum" : { "$sum" : "$Channels.Value" },

"documentAvg" : { "$avg" : "$Channels.Value" }

}

}

] )