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]}}}
}
}
,
{
$match : {
…,
displayTime: {$gte "$fourteenDaysAgo"}
}
},
{
$project: {
..}
}
]