[{"_id":ObjectId("5e7389e66fff4be5981d56eb"),"sessionId":"f960e3db-838c-42aa-95ce-a807096f7036","date":"12-02-2020","hour":"13","month":"02","time":"13:46:50","weekDay":"Wednesday"},{"_id":ObjectId("5e7389e66fff4be5981d56ec"),"sessionId":"f960e3db-838c-42aa-95ce-a807096f7036","date":"12-02-2020","hour":"13","month":"02","time":"13:46:50","weekDay":"Wednesday"},{"_id":ObjectId("5e7389e66fff4be5981d56ed"),"sessionId":"f960e3db-838c-42aa-95ce-a807096f7035","date":"12-02-2020","hour":"13","month":"02","time":"13:46:50","weekDay":"Wednesday"},{"_id":ObjectId("5e7389e66fff4be5981d56ee"),"sessionId":"f960e3db-838c-42aa-95ce-a807096f7045","date":"12-02-2020","hour":"13","month":"02","time":"13:46:50","weekDay":"Wednesday"},{"_id":ObjectId("5e7389e66fff4be5981d56ef"),"sessionId":"f960e3db-838c-42aa-95ce-a807096f7035","date":"12-02-2020","hour":"14","month":"02","time":"13:46:50","weekDay":"Wednesday"},{"_id":ObjectId("5e738a856fff4be5981d56f0"),"sessionId":"f960e3db-838c-42aa-95ce-a807096f111","date":"12-02-2020","hour":"13","month":"02","time":"13:46:50","weekDay":"Wednesday"},{"_id":ObjectId("5e738a856fff4be5981d56f1"),"sessionId":"f960e3db-838c-42aa-95ce-a807096f111","date":"12-02-2020","hour":"13","month":"02","time":"13:46:50","weekDay":"Wednesday"},{"_id":ObjectId("5e738a856fff4be5981d56f2"),"sessionId":"f960e3db-838c-42aa-95ce-a807096f111","date":"12-02-2020","hour":"13","month":"02","time":"13:46:50","weekDay":"Wednesday"},{"_id":ObjectId("5e738a856fff4be5981d56f3"),"sessionId":"f960e3db-838c-42aa-95ce-a807096f111","date":"12-02-2020","hour":"13","month":"02","time":"13:46:50","weekDay":"Wednesday"},{"_id":ObjectId("5e738a856fff4be5981d56f4"),"sessionId":"f960e3db-838c-42aa-95ce-a807096f111","date":"12-02-2020","hour":"14","month":"02","time":"13:46:50","weekDay":"Wednesday"},{"_id":ObjectId("5e738cca6fff4be5981d56f5"),"sessionId":"f960e3db-838c-42aa-95ce-a807096f111","date":"12-02-2020","hour":"11","month":"02","time":"13:46:50","weekDay":"Wednesday"},{"_id":ObjectId("5e738cca6fff4be5981d56f6"),"sessionId":"f960e3db-838c-42aa-95ce-a807096f111","date":"12-02-2020","hour":"11","month":"02","time":"13:46:50","weekDay":"Wednesday"},{"_id":ObjectId("5e738cca6fff4be5981d56f7"),"sessionId":"f960e3db-838c-42aa-95ce-a807096f111","date":"12-02-2020","hour":"11","month":"02","time":"13:46:50","weekDay":"Wednesday"},{"_id":ObjectId("5e738cca6fff4be5981d56f8"),"sessionId":"f960e3db-838c-42aa-95ce-a807096f111","date":"12-02-2020","hour":"11","month":"02","time":"13:46:50","weekDay":"Wednesday"},{"_id":ObjectId("5e738cca6fff4be5981d56f9"),"sessionId":"f960e3db-838c-42aa-95ce-a807096f111","date":"12-02-2020","hour":"11","month":"02","time":"13:46:50","weekDay":"Wednesday"},{"_id":ObjectId("5e738ddc6fff4be5981d56fa"),"sessionId":"f960e3db-838c-42aa-95ce-a807096f111","date":"22-02-2020","hour":"11","month":"02","time":"13:46:50","weekDay":"Wednesday"},{"_id":ObjectId("5e738ddc6fff4be5981d56fb"),"sessionId":"f960e3db-838c-42aa-95ce-a807096f111","date":"22-02-2020","hour":"11","month":"02","time":"13:46:50","weekDay":"Wednesday"},{"_id":ObjectId("5e738ddc6fff4be5981d56fc"),"sessionId":"f960e3db-838c-42aa-95ce-a807096f111","date":"22-02-2020","hour":"11","month":"02","time":"13:46:50","weekDay":"Wednesday"},{"_id":ObjectId("5e738ddc6fff4be5981d56fd"),"sessionId":"f960e3db-838c-42aa-95ce-a807096f111","date":"22-02-2020","hour":"11","month":"02","time":"13:46:50","weekDay":"Wednesday"},{"_id":ObjectId("5e738ddc6fff4be5981d56fe"),"sessionId":"f960e3db-838c-42aa-95ce-a807096f111","date":"22-02-2020","hour":"11","month":"02","time":"13:46:50","weekDay":"Wednesday"}]

db.collection.aggregate([{$group:{_id:{date:"$date",hour:"$hour"},sessions:{$addToSet:"$sessionId"}}},{$set:{sessions:{$size:"$sessions"}}},{$group:{_id:"$_id.date",hour:{$push:"$_id.hour"},sessions:{$push:"$sessions"}}},{$set:{data:{$range:[0,{$size:"$hour"}]}}},{$set:{data:{$map:{input:"$data",as:"idx",in:{k:{$arrayElemAt:["$hour","$$idx"]},v:{$arrayElemAt:["$sessions","$$idx"]}}}}}},{$set:{v:{$arrayToObject:"$data"}}},{$project:{data:{k:"$_id",v:"$v"}}},{$set:{data:{$arrayToObject:"$data"}}},{$replaceRoot:{newRoot:"$data"}}])