我有一个叫ActivityCollection的收藏。其中有许多字段,但我只想得到两个字段,名称、活动和所有活动的标签。我还想计算每个活动和标记的总数。要获得更清晰的理解,请参见下面给出的图像
发布于 2017-11-15 14:11:25
假设您的ActivityCollection中有以下数据模型:
{
"_id" : ObjectId("5a0c4894e465dc895af90d2c"),
"activity" : "Phone Call",
"tag" : "Addiction"
}
{
"_id" : ObjectId("5a0c48a2e465dc895af90d2d"),
"activity" : "Phone Call",
"tag" : "Family Issue"
}
{
"_id" : ObjectId("5a0c48aee465dc895af90d2e"),
"activity" : "Email",
"tag" : "Family Issue"
}
{
"_id" : ObjectId("5a0c48b9e465dc895af90d2f"),
"activity" : "Email",
"tag" : "Depression"
}下面的聚合作业将返回仪表板所需的数据::
根据活动进行计数:
db.ActivityCollection.aggregate([{$group:{_id:"$activity", count:{$sum:1}}}])用于基于标记的计数:
db.ActivityCollection.aggregate([{$group:{_id:"$tag", count:{$sum:1}}}])下面的结果将分别是
以活动为基础:
{ "_id" : "Email", "count" : 2 }
{ "_id" : "Phone Call", "count" : 2 }对于基于标签的:
{ "_id" : "Depression", "count" : 1 }
{ "_id" : "Family Issue", "count" : 2 }
{ "_id" : "Addiction", "count" : 1 }https://stackoverflow.com/questions/47306094
复制相似问题