Database
[{"_id":ObjectId("5fec3b978b34e8b047b7ae14"),"duration":20.0,"createdOn":ISODate("2020-12-16T22:28:44.000Z"),"ClockInTime":ISODate("2020-12-31T14:57:13.041Z"),"states":"UPLOADING"},{"_id":ObjectId("5fec3b978b34e8b047b7ae15"),"duration":20.0,"createdOn":ISODate("2020-12-16T21:04:16.000Z"),"hasIntracted":false,"ClockInTime":ISODate("2020-12-31T14:57:13.084Z"),"states":"PROCESSED"},{"_id":ObjectId("5fec3b978b34e8b047b7ae16"),"duration":20.0,"createdOn":ISODate("2020-12-02T07:21:48.000Z"),"hasIntracted":true,"ClockInTime":ISODate("2020-12-31T14:57:13.086Z"),"states":"PROCESSED"},{"_id":ObjectId("5fec3b978b34e8b047b7ae17"),"duration":20.0,"createdOn":ISODate("2020-12-20T19:33:34.000Z"),"hasIntracted":true,"ClockInTime":ISODate("2020-12-31T14:57:13.087Z"),"states":"PROCESSED"},{"_id":ObjectId("5fec3b978b34e8b047b7ae18"),"duration":20.0,"createdOn":ISODate("2020-12-25T04:11:16.000Z"),"hasIntracted":true,"ClockInTime":ISODate("2020-12-31T14:57:13.088Z"),"states":"PROCESSED"},{"_id":ObjectId("5fec3b978b34e8b047b7ae19"),"duration":20.0,"createdOn":ISODate("2020-12-09T06:45:23.000Z"),"hasIntracted":false,"ClockInTime":ISODate("2020-12-31T14:57:13.089Z"),"states":"PROCESSED"},{"_id":ObjectId("5fec3b978b34e8b047b7ae1a"),"duration":20.0,"createdOn":ISODate("2020-12-08T23:34:37.000Z"),"hasIntracted":true,"ClockInTime":ISODate("2020-12-31T14:57:13.090Z"),"states":"PROCESSED"},{"_id":ObjectId("5fec3b978b34e8b047b7ae1b"),"duration":20.0,"createdOn":ISODate("2020-12-10T07:26:24.000Z"),"hasIntracted":true,"ClockInTime":ISODate("2020-12-31T14:57:13.091Z"),"states":"PROCESSED"},{"_id":ObjectId("5fec3b978b34e8b047b7ae1c"),"duration":20.0,"createdOn":ISODate("2020-12-28T23:33:18.000Z"),"hasIntracted":false,"ClockInTime":ISODate("2020-12-31T14:57:13.093Z"),"states":"PROCESSED"},{"_id":ObjectId("5fec3b978b34e8b047b7ae1d"),"duration":20.0,"createdOn":ISODate("2020-12-27T04:44:35.000Z"),"hasIntracted":true,"ClockInTime":ISODate("2020-12-31T14:57:13.094Z"),"states":"PROCESSED"},{"_id":ObjectId("5fec3b978b34e8b047b7ae1e"),"duration":20.0,"createdOn":ISODate("2020-12-09T02:03:22.000Z"),"hasIntracted":true,"ClockInTime":ISODate("2020-12-31T14:57:13.095Z"),"states":"PROCESSED"},{"_id":ObjectId("5fec3b978b34e8b047b7ae1f"),"duration":20.0,"createdOn":ISODate("2020-11-28T23:37:00.000Z"),"hasIntracted":false,"ClockInTime":ISODate("2020-12-31T14:57:13.097Z"),"states":"PROCESSED"},{"_id":ObjectId("5fec3b978b34e8b047b7ae20"),"duration":20.0,"createdOn":ISODate("2020-12-19T02:36:47.000Z"),"hasIntracted":true,"ClockInTime":ISODate("2020-12-31T14:57:13.098Z"),"states":"PROCESSED"},{"_id":ObjectId("5fec3b978b34e8b047b7ae21"),"duration":20.0,"createdOn":ISODate("2020-12-19T00:42:30.000Z"),"hasIntracted":true,"ClockInTime":ISODate("2020-12-31T14:57:13.099Z"),"states":"PROCESSED"},{"_id":ObjectId("5fec3b978b34e8b047b7ae22"),"duration":20.0,"createdOn":ISODate("2020-12-04T23:47:35.000Z"),"hasIntracted":false,"ClockInTime":ISODate("2020-12-31T14:57:13.107Z"),"states":"PROCESSED"},{"_id":ObjectId("5fec3b978b34e8b047b7ae23"),"duration":20.0,"createdOn":ISODate("2020-12-22T02:36:28.000Z"),"hasIntracted":true,"ClockInTime":ISODate("2020-12-31T14:57:13.109Z"),"states":"PROCESSED"},{"_id":ObjectId("5fec3b978b34e8b047b7ae24"),"duration":20.0,"createdOn":ISODate("2020-11-28T02:52:00.000Z"),"hasIntracted":true,"ClockInTime":ISODate("2020-12-31T14:57:13.111Z"),"states":"PROCESSED"},{"_id":ObjectId("5fec3b978b34e8b047b7ae25"),"duration":20.0,"createdOn":ISODate("2020-12-03T02:41:43.000Z"),"hasIntracted":true,"ClockInTime":ISODate("2020-12-31T14:57:13.112Z"),"states":"PROCESSED"},{"_id":ObjectId("5fec3b978b34e8b047b7ae26"),"duration":20.0,"createdOn":ISODate("2020-12-11T21:31:22.000Z"),"hasIntracted":false,"ClockInTime":ISODate("2020-12-31T14:57:13.113Z"),"states":"PROCESSED"},{"_id":ObjectId("5fec3b978b34e8b047b7ae27"),"duration":20.0,"createdOn":ISODate("2020-12-07T23:31:56.000Z"),"hasIntracted":false,"ClockInTime":ISODate("2020-12-31T14:57:13.114Z"),"states":"PROCESSED"}]
Query
db.collection.aggregate([{$match:{states:"PROCESSED"}},{$group:{_id:{month:{$month:"$createdOn"},year:{$year:"$createdOn"}},count:{$sum:1},date:{$first:"$createdOn"}}},{$group:{_id:"$_id.year",data:{$push:"$$ROOT"}}},{$set:{data:{$map:{input:"$data",in:{k:{$toString:"$$this._id.month"},v:"$$this.count"}}}}},{$set:{data:{$arrayToObject:"$data"}}},{$set:{data:[{k:{$toString:"$_id"},v:"$data"}]}},{$replaceRoot:{newRoot:{$arrayToObject:"$data"}}}])