[{"transaction_id":"e10cc8d64204394cd35329a88dc4ab8f","timestamp":"2021-05-11 17:47:50","client_id":"chae@aklas.kr","ip":"172.69.34.31","level":"OK","request":{"method":"POST","status_code":200,"status_name":"Ok","url":"/ocr/driver"},"bytes":297,"message":"Status authenticated successfully"},{"transaction_id":"e10cc8d64204394cd35329a88dc4ab8f","timestamp":"2021-05-11 17:47:50","client_id":"chae@kkk.kr","ip":"172.69.34.31","level":"OK","request":{"method":"POST","status_code":200,"status_name":"Ok","url":"/status/driver"},"bytes":297,"message":"Status authenticated successfully"}]

db.collection.aggregate({"$facet":{"ocr":[{$match:{client_id:{$regex:"^chae@"},"request.url":{$regex:"^\/ocr"}}},{"$group":{"_id":{$substr:["$timestamp",0,10]},count:{$sum:1}}},{"$sort":{"count":-1}}],"status":[{$match:{client_id:{$regex:"^chae@"},"request.url":{$regex:"^\/status"}}},{"$group":{"_id":{$substr:["$timestamp",0,10]},count:{$sum:1}}},{"$sort":{"count":-1}}]}})