Database

[{"created_at":"2022-01-02T00:00:00","type":"car"},{"created_at":"2022-01-05T00:00:00","type":"car"},{"created_at":"2022-01-10T00:00:00","type":"car"}]

Query

db.collection.aggregate([{$project:{type:1,created_at:{$dateFromString:{dateString:"$created_at"}}}},{"$match":{"created_at":{"$gte":ISODate("2022-01-01"),"$lte":ISODate("2022-01-22")}}},{$group:{_id:"total",totalq:{$sum:1},maxd:{$max:"$created_at"},mind:{$min:"$created_at"}}},{$project:{_id:0,total_result_query:{$toInt:"$totalq"},total_days_day_filter:{$toInt:{$dateDiff:{startDate:"$mind",endDate:"$maxd",unit:"day"}}},total_days_search_filter:{$toInt:{$dateDiff:{startDate:ISODate("2022-01-01"),endDate:ISODate("2022-01-22"),unit:"day"}}}}}])

Result