[{_id:1,status:"active",sale:4,createdAt:"2019-10-08 08:46:19"},{_id:2,status:"inactive",sale:5,createdAt:"2019-10-08 06:41:19"},{_id:3,status:"inactive",sale:5,createdAt:"2019-10-08 02:01:19"}]

db.collection.aggregate([{$group:{_id:{$dayOfMonth:{$dateFromString:{dateString:"$createdAt"}}},inactive:{$sum:{$cond:[{$eq:["$status","inactive"]},1,0]}},active:{$sum:{$cond:[{$eq:["$status","inactive"]},0,1]}},salesOfInactive:{$sum:{$cond:[{$eq:["$status","inactive"]},"$sale",0]}},salesOfActive:{$sum:{$cond:[{$eq:["$status","inactive"]},0,"$sale"]}}}}])