MongoDB connector not working with added field
We are using the query below to filter for displayTime $gte "$fourteenDaysAgo", which is the added field. It doesn't work in Domo, but returns expected results in db explorer. Does anybody have any ideas? [ { $addField: { fourteenDaysAgo: { $trunc: {$toInt: {$divide:[{$subtract: [{$toLong: "$$NOW"} , 1209600000]},1000]}}}…