Skip to content

Instantly share code, notes, and snippets.

@johnlpage
Last active February 24, 2022 12:11
Show Gist options
  • Save johnlpage/89223a84f29aeab995c51e8828fddd3e to your computer and use it in GitHub Desktop.
Save johnlpage/89223a84f29aeab995c51e8828fddd3e to your computer and use it in GitHub Desktop.
[{
$group: {
_id: {
date: {
$dateTrunc: {date: "$date", unit: "day"}
},
type: "$type"
},
max: { $max: "$reading" },
min: { $min: "$reading" }
}
}, {
$set: {
used: { $subtract: ["$max", "$min"] }
}
}]
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment