Database
[{"_id":1,"name":"User1","totalOranges":800,"sectional":{"1724716800":100,"1724630400":200,"1724361600":50,"1724092800":150,"1723507200":300}},{"_id":2,"name":"User2","totalOranges":360,"sectional":{"1724716800":80,"1724630400":100,"1724544000":50,"1724457600":70,"1723152000":60}},{"_id":3,"name":"User3","totalOranges":900,"sectional":{"1724716800":200,"1724544000":100,"1724092800":50,"1724006400":250,"1722288000":300}},{"_id":4,"name":"User4","totalOranges":1200,"sectional":{"1724716800":300,"1724092800":250,"1723152000":100,"1722460800":150,"1721606400":400}},{"_id":5,"name":"User5","totalOranges":1300,"sectional":{"1724630400":400,"1723507200":250,"1722460800":200,"1721606400":150,"1720752000":300}}]
Query
db.collection.aggregate([{$addFields:{inbetweenTimePeriod:{$reduce:{input:{$filter:{input:{$objectToArray:"$sectional"},as:"item",cond:{$gte:[{$toLong:"$$item.k"},{$divide:[{$subtract:[{$toLong:"$$NOW"},604800000]},1000]}]}}},initialValue:0,in:{$add:["$$value","$$this.v"]}}}}},{$sort:{inbetweenTimePeriod:-1}}])