Skip to content

Instantly share code, notes, and snippets.

@anapaulagomes

anapaulagomes/gist:4b27c5557cf0abf2fde2461bbbbfe51b

Created May 20, 2016 02:03
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save anapaulagomes/4b27c5557cf0abf2fde2461bbbbfe51b to your computer and use it in GitHub Desktop.
Save anapaulagomes/4b27c5557cf0abf2fde2461bbbbfe51b to your computer and use it in GitHub Desktop.
Download ZIP
Agrupa registros por hora
Raw
gistfile1.txt
db.checkins.aggregate(
{ "$match": {"base.cidade": "newyork", "local.nome": "Starbucks"}},
{ "$project": { "h":{"$hour":"$data"} } },
{ "$group":{ "_id": { "hour":"$h"}, "total":{ "$sum": 1} } }, {$sort: {"_id.hour": 1}})
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment