[{"id":10001,"name":"Test 1","status":"live","traffics":[{"id":"1a3s5d435a4sd","status":"TERM"},{"id":"1a3s5d44as54d35a4sd","status":"CMP"},{"id":"a3s5d454asd34asd","status":""},{"id":"1a35sd45a4sd34asd3","status":"TERM"},{"id":"as35d435a4sd354as3d43asd4","status":"CMP"},{"id":"135as4d5a4sd354a3s5d43asd","status":"CMP"},{"id":"123as1d31a3d12ads13as","status":"TERM"}]},{"id":10002,"name":"Test 1","status":"live","traffics":[{"id":"1a3s5d435a4sd","status":"QF"},{"id":"1a3s5d44as54d35a4sd","status":"CMP"},{"id":"a3s5d454asd34asd","status":""},{"id":"1a35sd45a4sd34asd3","status":"TERM"},{"id":"as35d435a4sd354as3d43asd4","status":"CMP"},{"id":"135as4d5a4sd354a3s5d43asd","status":"CMP"},{"id":"123as1d31a3d12ads13as","status":"TERM"}]},{"id":10003,"name":"Test 1","status":"live","traffics":[{"id":"1a3s5d435a4sd","status":"CMP"},{"id":"1a3s5d44as54d35a4sd","status":"CMP"},{"id":"a3s5d454asd34asd","status":""},{"id":"1a35sd45a4sd34asd3","status":"TERM"},{"id":"as35d435a4sd354as3d43asd4","status":"CMP"},{"id":"135as4d5a4sd354a3s5d43asd","status":"CMP"},{"id":"123as1d31a3d12ads13as","status":"CMP"}]},{"id":10004,"name":"Test 1","status":"live","traffics":[{"id":"1a3s5d435a4sd","status":"TERM"},{"id":"1a3s5d44as54d35a4sd","status":"CMP"},{"id":"a3s5d454asd34asd","status":""},{"id":"1a35sd45a4sd34asd3","status":"TERM"},{"id":"as35d435a4sd354as3d43asd4","status":""},{"id":"135as4d5a4sd354a3s5d43asd","status":"TERM"},{"id":"123as1d31a3d12ads13as","status":"TERM"}]}]

db.collection.aggregate({$project:{id:1,name:1,status:1,starts:{$size:"$traffics"},completes:{$size:{$filter:{input:"$traffics",as:"item",cond:{$eq:["$$item.status","CMP"]}}}},terminates:{$size:{$filter:{input:"$traffics",as:"item",cond:{$eq:["$$item.status","TERM"]}}}},abandons:{$size:{$filter:{input:"$traffics",as:"item",cond:{$eq:["$$item.status",""]}}}},_id:0}})