该文档展示了一个MongoDB的聚合框架查询，用于筛选在特定时间范围内、由特定operatorId操作的数据，并对pullSpent、personalSpent和contentSpent进行统计。它进一步过滤了每个类别中小于20的值，并计算了它们占总记录的比例。
db.t_verify_stat.aggregate([
{
$match: {
updatedTime: {
$gte: ISODate("2023-02-10 00:00:00"),
$lte: ISODate("2023-02-10 00:10:00"),
},
operatorId: 63,
dataType: 1
}
}
,
{
$group: {
_id: "$operatorId",
"operatorName": {
$first: "$operatorName"
},
"pullSpentArray": {
$push: "$pullSpent"
},
"personalSpentArray": {
$push: "$personalSpent"
},
"contentSpentArray": {
$push: "$contentSpent"
},
"totalCount": {
$sum: 1
}
}
},
{
$project: {
"totalCount": 1,
"filterPullArray": {
$filter: {
input: "$pullSpentArray",
as: "item",
cond: {
$lte: ["$$item", NumberInt("20")]
}
}
},
"filterPersonalArray": {
$filter: {
input: "$personalSpentArray",
as: "item",
cond: {
$lte: ["$$item", NumberInt("20")]
}
}
},
"filterContentArray": {
$filter: {
input: "$contentSpentArray",
as: "item",
cond: {
$lte: ["$$item", NumberInt("20")]
}
}
}
}
},
{
$project: {
"totalCount": 1,
"pullSize": {
$size: ["$filterPullArray"]
},
"personalSize": {
$size: ["$filterPersonalArray"]
},
"contentSize": {
$size: ["$filterContentArray"]
}
}
},
{
$project: {
"pull": {
$divide: ["$pullSize", "$totalCount"]
},
"personal": {
$divide: ["$personalSize", "$totalCount"]
},
"content": {
$divide: ["$contentSize", "$totalCount"]
}
}
}
])
扫一扫
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
