[{"_id":ObjectId("610bcecea7f31aaa40b08186"),"tag":"prod","document":"RUT","fields":{"9-1-1-1":{"text":"1018462101","confidence":1},"9-1-1-2":{"text":"32","confidence":1},"9-1-1-3":{"text":"*******","confidence":0.99},"9-1-1-4":{"text":"*******","confidence":0.99},"9-1-1-5":{"text":"*******","confidence":0.99},"9-1-1-6":{"text":"CATALINA","confidence":0.99},"9-1-1-7":{"text":"8299","confidence":1}},"status":"OK","created_at":ISODate("2021-08-05T11:43:10.110Z")},{"_id":ObjectId("610bced6a7f31aaa40b08187"),"tag":"prod","document":"FNA","fields":{"20-20-4-4-1-1-1-1-2-1":{"text":"","confidence":0},"20-20-4-4-1-1-1-1-3-1":{"text":"","confidence":0},"20-20-4-4-1-1-1-1-4-1":{"text":"","confidence":0},"20-20-4-4-1-1-1-1-5-1":{"text":"","confidence":0}},"status":"OK","created_at":ISODate("2021-08-05T11:43:18.706Z")},{"_id":ObjectId("610bcef70b1451dacf81bf32"),"tag":"prod","document":"TAX","fields":{"20-19-5-1-2-1-1-1-2-1":{"text":"6729000","confidence":1},"20-19-5-1-2-1-1-1-3-1":{"text":"7443000","confidence":1},"20-19-5-1-2-1-1-1-4-1":{"text":"54895000","confidence":1},"20-19-5-1-2-1-1-1-5-1":{"text":"16582000","confidence":0.99},"20-19-5-1-2-1-1-1-6-1":{"text":"16582000","confidence":1},"20-19-5-1-2-1-1-1-7-1":{"text":"36083000","confidence":1},"20-19-5-1-2-1-1-1-8-1":{"text":"2000","confidence":1},"20-19-5-1-2-1-1-1-9-1":{"text":"0","confidence":0.7},"20-19-5-1-2-1-1-1-10-1":{"text":"0","confidence":0.7},"20-19-5-1-2-1-1-1-11-1":{"text":"0","confidence":1},"20-19-5-1-2-1-1-1-12-1":{"text":"0","confidence":1},"20-19-5-1-2-1-1-1-13-1":{"text":"2000","confidence":1},"20-19-5-1-2-1-1-1-14-1":{"text":"0","confidence":1},"20-19-5-1-2-1-1-1-15-1":{"text":"0","confidence":0.7},"20-19-5-1-2-1-1-1-16-1":{"text":"0","confidence":0.7},"20-19-5-1-2-1-1-1-17-1":{"text":"0","confidence":1},"20-19-5-1-2-1-1-1-18-1":{"text":"0","confidence":1},"20-19-5-1-2-1-1-1-19-1":{"text":"0","confidence":1},"20-19-5-1-2-1-1-1-20-1":{"text":"52667000","confidence":1},"20-19-5-1-2-1-1-1-21-1":{"text":"16582000","confidence":1},"20-19-5-1-2-1-1-1-22-1":{"text":"0","confidence":1},"20-19-5-1-2-1-1-1-23-1":{"text":"0","confidence":1},"20-19-5-1-2-1-1-1-24-1":{"text":"0","confidence":1},"20-19-5-1-2-1-1-1-25-1":{"text":"36085000","confidence":0.99},"20-19-5-1-2-1-1-1-26-1":{"text":"0","confidence":1},"20-19-5-1-2-1-1-1-27-1":{"text":"0","confidence":1},"20-19-5-1-2-1-1-1-28-1":{"text":"0","confidence":1},"20-19-5-1-2-1-1-1-29-1":{"text":"0","confidence":1},"20-19-5-1-2-1-1-1-30-1":{"text":"0","confidence":0.7},"20-19-5-1-2-1-1-1-31-1":{"text":"0","confidence":1},"20-19-5-1-2-1-1-1-32-1":{"text":"0","confidence":0.7},"20-19-5-1-2-1-1-1-33-1":{"text":"0","confidence":1},"20-19-5-1-2-1-1-1-34-1":{"text":"0","confidence":1},"20-19-5-1-2-1-1-1-35-1":{"text":"0","confidence":1},"20-19-5-1-2-1-1-1-36-1":{"text":"0","confidence":1},"20-19-5-1-2-1-1-1-37-1":{"text":"0","confidence":1},"20-19-5-1-2-1-1-1-38-1":{"text":"0","confidence":1},"20-19-5-1-2-1-1-1-39-1":{"text":"0","confidence":1},"20-19-5-1-2-1-1-1-40-1":{"text":"0","confidence":1},"20-19-5-1-2-1-1-1-41-1":{"text":"0","confidence":1},"20-19-5-1-2-1-1-1-42-1":{"text":"0","confidence":0.7},"20-19-5-1-2-1-1-1-43-1":{"text":"0","confidence":1}},"status":"OK","created_at":ISODate("2021-08-05T11:43:51.466Z")}]

db.collection.aggregate([{"$match":{"$and":[{tag:"prod",status:"OK",created_at:{$gte:ISODate("2021-01-01"),$lt:ISODate("2022-01-01")}},]}},{"$addFields":{"fields":{"$objectToArray":"$fields"}}},{"$unwind":"$fields"},{$match:{"fields.v.confidence":{$gte:0.99}}},{$group:{_id:{doc:"$document",fname:"$fields.k"},"dataK":{$first:"$fields.k"},"dataV":{$sum:1}}},{$project:{"data.k":"$dataK","data.v":"$dataV"}},{$group:{_id:"$_id.doc",fields:{$push:"$data"}}},{$project:{"fields":{"$arrayToObject":"$fields"}}},])