Database
[{"metadata":{"sensorId":5578,"type":"temperature"},"timestamp":ISODate("2021-05-18T00:00:00.000Z"),"temp":72},{"metadata":{"sensorId":5578,"type":"humidity"},"timestamp":ISODate("2021-05-18T00:00:00Z"),"humpercent":78}]
Query
db.collection.aggregate([{$sort:{timestamp:1}},{$group:{_id:{sensorId:"$metadata.sensorId"},temp:{$push:"$temp"},humidity:{$push:"$humpercent"}}}])