[{"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([{"$group":{"_id":{"reg":{"$switch":{"branches":[{"case":{"$and":[{"$regexMatch":{"input":"$client_id","regex":"^chae@"}},{"$regexMatch":{"input":"$request.url","regex":"^/ocr"}}]},"then":"chae-ocr"},{"case":{"$and":[{"$regexMatch":{"input":"$client_id","regex":"^chae@"}},{"$regexMatch":{"input":"$request.url","regex":"^/status"}}]},"then":"chae-status"}],"default":"other"}},"time":{"$substrCP":["$timestamp",0,10]}},"count":{"$sum":1}}},{"$project":{"_id":"$_id.time","count":1,"searched":"$_id.reg"}}])