Database
db={"temperaterdata":[{"organization_id":37,resulttime:"2020-05-01 00:00",temperature:100.67,userid:233},{"organization_id":37,resulttime:"2020-05-02 00:00",temperature:98.56,userid:233},{"organization_id":37,resulttime:"2020-05-29 00:00",temperature:99.96,userid:233},{"organization_id":37,resulttime:"2020-05-29 00:00",temperature:99.96,userid:256},{"organization_id":37,resulttime:"2020-05-15 00:00",temperature:100.67,userid:256},{"organization_id":37,resulttime:"2020-05-17 00:00",temperature:98.56,userid:256}]}
Query
db.temperaterdata.aggregate([{"$match":{"organization_id":37,"resulttime":{"$gte":"2020-05-01 00:00","$lte":"2020-05-29 23:59"}}},{"$sort":{"userid":1,"temperature":1}},{"$group":{"_id":"$userid","maxTemperature":{"$last":"$$ROOT"},"minTemperature":{"$first":"$$ROOT"}}},{"$project":{"maxresulttime":"$maxTemperature.resulttime","minresulttime":"$minTemperature.resulttime","maxTemperature":"$maxTemperature.temperature","minTemperature":"$minTemperature.temperature"}}])