Database
[{State_Name:"Gujarat",Commodity_Code:"123",Reported_Date_str:"2021-01-05"},{State_Name:"Gujarat",Commodity_Code:"123",Reported_Date_str:"2021-05-05"},{State_Name:"Gujarat",Commodity_Code:"125",Reported_Date_str:"2021-06-05"}]
Query
db.collection.aggregate([{$match:{State_Name:{$eq:"Gujarat"}}},{$group:{_id:"$Commodity_Code",reported_date:{$max:"$Reported_Date_str"}}},{$sort:{"Reported_Date_str":-1}},{"$set":{"commodity_Code":"$_id"}}])