Database

[{device:1,date:"2022/10/01",time:"00:05:00",voltage:15.0,amperage:2.5},{device:1,date:"2022/10/01",time:"00:10:00",voltage:28.0,amperage:12.5},{device:1,date:"2022/10/01",time:"00:15:00",voltage:35.0,amperage:42.5},{device:1,date:"2022/10/01",time:"00:20:00",voltage:33.0,amperage:2.5},{device:2,date:"2022-12-01",time:"00:05:00",voltage:15.0,amperage:2.5},{device:2,date:"2022-12-01",time:"00:10:00",voltage:28.0,amperage:12.5},{device:2,date:"2022/10/01",time:"00:15:00",voltage:35.0,amperage:42.5},{device:2,date:"2022/10/01",time:"00:20:00",voltage:33.0,amperage:2.5},{device:3,date:"2022/10/01",time:"00:05:00",voltage:15.0,amperage:2.5},{device:3,date:"2022/10/01",time:"00:15:00",voltage:35.0,amperage:2.5},{device:4,date:"2022/10/01",time:"00:10:00",voltage:28.0,amperage:12.5},{device:4,date:"2022/10/01",time:"00:20:00",voltage:33.0,amperage:2.5}]

Query

db.collection.aggregate([{$match:{device:{$in:[1,2,3]},date:"2022/10/01",voltage:{$gte:27.0}}},{$group:{_id:"$time",device:{"$addToSet":"$device"},amperage:{$min:"$amperage"},root:{$push:"$$ROOT"}}},{$match:{device:{$all:[1,2,3]}}}])

Result