Database
[{Tin:"5051",Status:"DOCUMENTED",Region:"ECE",ActionDateTime:ISODate("2022-08-21T00:46:24.000+00:00"),FM:"XYZ"},{Tin:"5051",Status:"DOCUMENTED",Region:"ECE",ActionDateTime:ISODate("2022-08-21T00:46:24.000+00:00"),FM:"XYZ"},{Tin:"5055",Status:"DOCUMENTED",Region:"ECE",ActionDateTime:ISODate("2022-08-21T00:46:24.000+00:00"),FM:"XYZ"},{Tin:"5055",Status:"DOCUMENTED",Region:"ECE",ActionDateTime:ISODate("2022-08-21T00:46:24.000+00:00"),FM:"XYZ"},{Tin:"5052",Status:"DOCUMENTED",Region:"CHN",ActionDateTime:ISODate("2022-08-21T00:46:24.000+00:00"),FM:"XYZ"},{Tin:"5053",Status:"DOCUMENTED",Region:"AMAP",ActionDateTime:ISODate("2022-08-21T00:46:24.000+00:00"),FM:"XYZ"}]
Query
db.collection.aggregate([{$group:{_id:"$Tin",count:{$sum:1}}},{$match:{count:{$gt:1}}},{"$lookup":{"from":"collection","localField":"_id","foreignField":"Tin","as":"docs"}},{"$unwind":"$docs"},{"$replaceRoot":{"newRoot":"$docs"}}])