mongodb-query

The $redact operator of the aggregation framework is your best option: db.collection.aggregate([ { “$redact”: { “$cond”: { “if”: { “$lt”: [ { “$add”: [ “$b”, “$c” ] }, 5 ] }, “then”: “$$KEEP”, “else”: “$$PRUNE” } }}, { “$project”: { “_id”: 0, “a”: 1 } } ]) The logical condition is made via $lt on … Read more

Though it should have been made more clear in your question, your output sample from source suggests that you are looking for: Total count of messages per “uid” Distinct count of values in “to” Distinct count of values in “from” Summary of counts per “hour” for each “uid” This is all possible in a single … Read more