MongoDb aggregations support javascript functions in $function https://www.mongodb.com/docs/v6.0/reference/operator/aggregation/function/ and $where https://www.mongodb.com/docs/v6.0/reference/operator/query/where clauses in aggregations… how do we use those in redash? do we just pass the function in a string so it passes javascript validation?
I’m getting Error running query: Unrecognized expression '$where' when attempting this