[{"completed":ISODate("2022-01-02T03:53:28.463Z"),"created":ISODate("2022-01-01T03:22:18.739Z"),"driverId":"B-72653","id":"1","total":66,"products":[{id:1,price:46,variant:{productId:162572,product:{id:162572,name:"Water Cooler",price:46,brand:{id:1,name:"Microsoft"}}}},{id:2,price:20,variant:{productId:94968,product:{id:94968,name:"Printer Paper",price:20,brand:{id:2,name:"Apple"}}}}]},{"completed":ISODate("2022-01-03T03:53:28.463Z"),"created":ISODate("2022-01-02T03:22:18.739Z"),"driverId":"B-72653","id":"2","total":40,"products":[{id:3,price:20,variant:{productId:94988,product:{id:94988,name:"Large Pencils",price:20,brand:{id:1,name:"Microsoft"}}}},{id:4,price:20,variant:{productId:88845,product:{id:88845,name:"Leather Jacket",price:20,brand:{id:2,name:"Apple"}}}}]},{"completed":ISODate("2021-08-26T09:53:28.463Z"),"created":ISODate("2021-08-26T01:22:18.739Z"),"driverId":"B-72653","id":"3","total":30,"products":[{id:5,price:10,variant:{productId:88847,product:{id:88847,name:"Big Apple",price:10,brand:{id:1,name:"Microsoft"}}}},{id:6,price:20,variant:{productId:90850,product:{id:90850,name:"Big Bash",price:20,brand:{id:2,name:"Apple"}}}}]},{"completed":ISODate("2021-03-26T07:53:28.463Z"),"created":ISODate("2021-03-26T02:22:18.739Z"),"driverId":"B-73123","id":"4","total":2,"products":[{id:7,price:10,variant:{productId:90846,product:{id:90846,name:"Snow Fall",price:10,brand:{id:1,name:"Microsoft"}}}},{id:8,price:20,variant:{productId:90411,product:{id:90411,name:"Shoes White",price:20,brand:{id:2,name:"Apple"}}}}]}]

db.collection.aggregate([{"$facet":{"Hourly":[{$group:{_id:{$hour:"$created"},total:{$sum:"$total"}}},{$sort:{_id:1}},{$group:{_id:null,result:{$push:{hour:"$_id",total:"$total"}}}}],Weekly:[{$group:{_id:{"$week":"$created"},total:{$sum:"$total"}}},{$sort:{_id:1}},{$group:{_id:null,result:{$push:{week:"$_id",total:"$total"}}}}],Monthly:[{$group:{_id:{$month:"$created"},total:{$sum:"$total"}}},{$sort:{_id:1}},{$group:{_id:null,result:{$push:{month:"$_id",total:"$total"}}}}],Yearly:[{$group:{_id:{$year:"$created"},total:{$sum:"$total"}}},{$sort:{_id:1}},{$group:{_id:null,result:{$push:{year:"$_id",total:"$total"}}}}]}},{"$addFields":{"Hourly":{"$arrayElemAt":["$Hourly",0]},"Weekly":{"$arrayElemAt":["$Weekly",0]},"Monthly":{"$arrayElemAt":["$Monthly",0]},"Yearly":{"$arrayElemAt":["$Yearly",0]}}},{"$addFields":{"Hourly":"$Hourly.result","Weekly":"$Weekly.result","Monthly":"$Monthly.result","Yearly":"$Yearly.result"}}])