[{"_id":ObjectId("5b96787ebe9d44528eaa18a1"),"values":[{"field1":1,"field2":4}],"user":"user10","date":"2018-09-09 00:00:00","type":"patient","extracted_date":"2018-09-11 10:58:18"},{"_id":ObjectId("5b96787ebe9d44528eaa18a0"),"values":[{"field1":1,"field2":3}],"user":"user10","date":"2018-09-09 00:00:00","type":"patient","extracted_date":"2018-09-10 10:58:18"},{"_id":ObjectId("5b96787ebe9d44528eaa18a2"),"values":[{"field11":2,"field2":10}],"user":"user11","date":"2018-09-05 00:00:00","type":"patient","extracted_date":"2018-09-10 10:58:18"}]

db.collection.aggregate([{"$match":{"type":"patient","date":{"$gte":"2018-09-05 00:00:00","$lte":"2018-09-18 00:00:00"}}},{"$sort":{"extracted_date":1}},{"$group":{"_id":{"type":"$type","user":"$user","date":"$date"},"id":{$last:"$_id"},"date":{$last:"$date"},"type":{$last:"$type"},"extracted_date":{$last:"$extracted_date"},"values":{$last:"$values"}}},{"$project":{"_id":0}}])