Notification query to MongoDB

notification-query.js

db.getCollection('apiai_responses').aggregate([
            {
                $match:
                    {
                        $and: [
                            { 'address.bot.id': '464021083618709' },
                            { 'timestamp': { $gte: '2018-01-15T15:00:00', $lte: '2018-01-15T16:00:00' } }
                        ]
                    }
            }
            ,
            {
                $group: {
                    _id: { botid: '$address.bot.id' },
                    count: { $sum: 1 },
                    fallback: { $sum: { $cond: [{ $eq: ['Default Fallback Intent', '$result.metadata.intentName'] }, 1, 0] } }
                }
            },
            {
                $project: {
                    count: '$count',
                    fallback: '$fallback',
                    percent: { $divide: ['$fallback', '$count'] }
                }
            }
        ])

• the time on the server is 3 hours more than in Chile.
• the notification interval is 1 elapsed hour.