10.js

var collName= 20180419 
/* 2018-04-18 00:00:00 to 2018-04-18 23:59:59 */
var dateRange= {"$gte":1524009600,"$lte":1524095999}
// -----------------------------------------------------
var queryDoc10= {}, paid= "59deb60085a3c22795133b02", free= "59dfe40a0a5037ff1c0bd8af", useSegId = free
queryDoc10= {"last_request_at": dateRange, "segments.segments.id":useSegId}
db.getCollection(`${collName}`).aggregate([ { $match: queryDoc10 },{ $group: {_id : null,/* 'Plan Names': { $push: { api_plan_name : "$custom_attributes.api_plan_name", "User email": "$email", "User id": "$user_id" } }, */ "Total no activity" : {"$sum":1} } }
/* ,{ $project: {_id:0, "Plan Names": "$Plan Names", "Client id" : "$client_id"} } */
] )