[{"_id":ObjectId("5f92b9efb7895affcd55ab8c"),"active":true,"assetData":{"asset1":{"average":4,"count":2,"dataPerHour":{"0":{"average":0,"count":0,"max":0,"min":0,"values":[{"time":"2020-10-23T11:08:38.928Z","value":0}]},"1":{"average":0,"count":0,"max":0,"min":0,"values":[{"time":"2020-10-23T11:08:38.928Z","value":0}]},"2":{"average":0,"count":0,"max":0,"min":0,"values":[{"time":"2020-10-23T11:08:38.928Z","value":0}]}},"max":0,"min":0},"asset2":{"average":0,"count":0,"dataPerHour":{"0":{"average":0,"count":0,"max":0,"min":0,"values":[{"time":"2020-10-23T11:08:38.928Z","value":0}]},"1":{"average":0,"count":0,"max":0,"min":0,"values":[{"time":"2020-10-23T11:08:38.928Z","value":0}]},"2":{"average":0,"count":0,"max":0,"min":0,"values":[{"time":"2020-10-23T11:08:38.928Z","value":0}]}},"max":0,"min":0},"asset3":{"average":0,"count":0,"dataPerHour":{"0":{"average":0,"count":0,"max":0,"min":0,"values":[{"time":"2020-10-23T11:08:38.928Z","value":0}]},"1":{"average":0,"count":0,"max":0,"min":0,"values":[{"time":"2020-10-23T11:08:38.928Z","value":0}]},"2":{"average":0,"count":0,"max":0,"min":0,"values":[{"time":"2020-10-23T11:08:38.928Z","value":0}]}},"max":0,"min":0}},"average":4,"count":2,"date":"2020-10-23T11:08:38.928Z","id":"string","max":0,"min":0,"parameterId":"string","parameterName":"string","parameterValue":0,"serviceId":"string"}]

db.collection.aggregate([{"$group":{"_id":null,"data":{"$push":"$assetData.asset1"}}},{"$project":{"average":{"$divide":[{"$reduce":{"input":"$data","initialValue":0,"in":{"$add":["$$value",{"$multiply":["$$this.count","$$this.average"]}]}}},{$reduce:{input:"$data",initialValue:0,in:{"$add":["$$value","$$this.count"]}}}]}}}])