Mongo average aggregation query with no group

Vote count:

0

I am trying to get the average of a whole field using the aggregation framework in Mongo. However i can't seem to find any example that uses it without a group parameter.

I have the following document structure:

 {
  "_id" : ObjectId("5352703b61d2739b2ea44e4d"),
  "Semana" : "2014-02-23 - 2014-03-01",
  "bolsaDeValores" : "7",
  "bvc" : "8",
  "dollar" : "76",
  "ecopetrol" : "51",
  "dollarPrice" : "18"
}

Basically what i want to do is get the average value of the bvc field, and any other numeric one, for the whole collection in the fastest possible way (without using MapReduce as it is less efficient than the Aggregation Framework).

I have tried to group on a greater than zero basis as well but to no avail:

db.EvaluatedSentiments.aggregate([{$group : {bvc : {$gt:0}}, {bvc : {$avg : "$bvc"}}}])

I appreciate any help you could provide.

References: Mongo aggregation manual

asked 36 secs ago

NicolasZ

3