alexrutherford/aggregate.sh

Created October 8, 2015 17:31

Star (0) You must be signed in to star a gist
Fork (0) You must be signed in to fork a gist

Select an option

Learn more about clone URLs
Clone this repository at <script src="https://gist.github.com/alexrutherford/00bf93da79dbc3d17552.js"></script>
Save alexrutherford/00bf93da79dbc3d17552 to your computer and use it in GitHub Desktop.

Download ZIP

Count most common page categories in MongoDB

Raw

aggregate.sh

	db.pages.aggregate([
	{$match:{id:{$exists:true}}},
	{$group:{_id:'$category',total:{$sum:1}}},
	{$sort:{total:-1}}
	])

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment