[{userId:"6udg",data:[{date:ISODate("2022-09-22"),hits:98},{date:ISODate("2022-10-23"),hits:88},{date:ISODate("2022-11-24"),hits:100},{date:ISODate("2022-11-24"),hits:145},{date:ISODate("2022-11-25"),hits:75}]}]

db.collection.aggregate([{"$match":{userId:"6udg"}},{"$addFields":{"last_seven_days":{data:{"$filter":{"input":"$data","as":"d","cond":{$lt:[{"$dateDiff":{"startDate":"$$d.date","endDate":"$$NOW","unit":"day"}},7]}}}},"last_month":{data:{"$filter":{"input":"$data","as":"d","cond":{$lt:[{"$dateDiff":{"startDate":"$$d.date","endDate":"$$NOW","unit":"month"}},1]}}}},"last_year":{data:{"$filter":{"input":"$data","as":"d","cond":{$lt:[{"$dateDiff":{"startDate":"$$d.date","endDate":"$$NOW","unit":"year"}},1]}}}}}},{"$addFields":{"last_seven_days":{avg:{$avg:"$last_seven_days.data.hits"}},"last_month":{avg:{$avg:"$last_month.data.hits"}},"last_year":{avg:{$avg:"$last_year.data.hits"}}}}])