[{"_id":ObjectId("608a6ee3e781511b7283c393"),"duration":0,"agent":"SIP/intellicon","queue":"sales","event":"LOGIN","startDateTime":"2021-04-29 13:27:21",/**String Type*/"endDateTime":"0000-00-00 00:00:00",/**String Type*/"channel":"fb_pages","__v":0,"createdAt":ISODate("2021-04-29T08:31:31.995Z"),"updatedAt":ISODate("2021-04-29T08:31:31.995Z")}]

db.collection.aggregate([{$group:{_id:{agent:"$agent",queue:"$queue",channel:"$channel"},loginTime:{"$sum":{"$cond":[{"$eq":["$event","LOGIN"]},{"$cond":[{"$eq":["$duration",0]},{$subtract:[new Date(),{$toDate:"$startDateTime"}]},"$duration"]},0]}},}}])