Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- let simpleQuery = (startDate, millis) => {
- return Entry.aggregate([{
- $match: {
- date: {
- $gte: startDate
- }
- }
- },
- {
- $project: {
- cpu: '$data.cpu',
- date: 1
- }
- },
- {
- $group: {
- _id: {
- $floor: {
- $divide: [{
- $subtract: ['$date', startDate]
- }, millis]
- }
- },
- avgCpu: {
- $avg: '$cpu'
- },
- avgDate: {
- $avg: {
- $sum: {
- $subtract: ['$date', TheEpoch]
- }
- }
- }
- }
- },
- {
- $project: {
- _id: 0,
- avg: '$avgCpu',
- date: '$avgDate'
- }
- },
- {
- $sort: {
- date: 1
- }
- }
- ])
- }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement