[{"_id":ObjectId("5ec8f74f32973c7b7cb7cce9"),"createdAt":ISODate("2020-05-23T10:13:35.012Z"),"updatedAt":ISODate("2020-08-20T13:37:09.861Z"),"name":"Patrick Jere"},{"_id":ObjectId("5ec8ef8a2b6e5f78fa20443c"),"createdAt":ISODate("2020-05-23T09:40:26.089Z"),"updatedAt":ISODate("2020-07-23T07:54:01.833Z"),"name":"Austine Wiga"},{"_id":ObjectId("5ed5e1a3962a3960ad85a1a2"),"createdAt":ISODate("2020-06-02T05:20:35.090Z"),"updatedAt":ISODate("2020-07-29T14:02:52.295Z"),"name":"Biasi Phiri"},{"_id":ObjectId("5ed629ec6d87382c608645d9"),"createdAt":ISODate("2020-06-02T10:29:00.204Z"),"updatedAt":ISODate("2020-06-02T10:29:00.204Z"),"name":"Chisambwe Kalusa"},{"_id":ObjectId("5ed8d21f42bc8115f67465a8"),"createdAt":ISODate("2020-06-04T10:51:11.546Z"),"updatedAt":ISODate("2020-06-04T10:51:11.546Z"),"name":"Wakun Moyo"}]

db.collection.aggregate([{$group:{_id:{$dateToString:{format:"%Y-%m",date:"$createdAt"}},new_users:{$sum:{$cond:[{$gte:["$createdAt",ISODate("2020-08-01")]},1,0]}},active_users:{$sum:{$cond:[{$gt:["$updatedAt",ISODate("2020-02-01")]},1,0]}},total_users:{$sum:1}}}])