let pipeline = [
{
$group: {
_id: "$user_id",
minTime: { $min: "$time" },
maxTime: { $max: "$time" }
}
},
{
$project: {
// Looking to take the most recent document, and the
// oldest document for a user and subtract their "weight"
// attribute
}
}
]
I am struggling with a MongoDB aggregate problem. I am currently looking to take the oldest document, matching "minTime" and the newest document with time matching "maxTime", and subtracting their "weight" attribute to basically get a net change for the user. How would I go about projecting this in the pipeline?
Read more here: https://stackoverflow.com/questions/66343063/mongodb-aggregate-projecting-min-and-max-documents
Content Attribution
This content was originally published by Nicholas Dullam at Recent Questions - Stack Overflow, and is syndicated here via their RSS feed. You can read the original post over there.