[{"key":1,expired:"2021-09-30 00:00:00",values:[{quantity:1},{quantity:2}]},{/** 30 days ago; should be excluded*/"key":2,expired:"2021-07-30 00:00:00",values:[{quantity:3},{quantity:4}]},{"key":3,expired:"2021-09-10 00:00:00",values:[{quantity:5},{quantity:6}]}]

db.collection.aggregate([{"$match":{key:{$in:[1,2,3]}}},{"$addFields":{"expired":{"$dateFromString":{"dateString":"$expired","format":"%Y-%m-%d %H:%M:%S","timezone":"America/New_York"}}}},{"$match":{$expr:{$gt:["$expired",{$subtract:["$$NOW",2592000000]}]}}},{"$group":{"_id":{"$dateToString":{"date":"$expired","format":"%Y-%m-%d","timezone":"America/New_York"}},"theVal":{"$sum":{$first:"$values.quantity"}}}},{"$project":{"dateOnly":{"$dateFromString":{"dateString":"$_id","format":"%Y-%m-%d","timezone":"America/New_York"}},"theVal":1}},{"$addFields":{today:{$gt:["$dateOnly",{$subtract:["$$NOW",86400000]}]},yesterday:{$gt:["$dateOnly",{$subtract:["$$NOW",172800000]}]},7days:{$gt:["$dateOnly",{$subtract:["$$NOW",604800000]}]},month:{$gt:["$dateOnly",{$subtract:["$$NOW",2592000000]}]}}},{"$group":{_id:null,today:{"$sum":{"$cond":{"if":"$today","then":"$theVal","else":0}}},yesterday:{"$sum":{"$cond":{"if":"$yesterday","then":"$theVal","else":0}}},7days:{"$sum":{"$cond":{"if":"$7days","then":"$theVal","else":0}}},month:{"$sum":{"$cond":{"if":"$month","then":"$theVal","else":0}}},}},{"$project":{_id:0,today:1,yesterday:1,7days:1,month:1}}])