Get averages from pre-aggregated reports in mongodb

Posted by Chris on Stack Overflow See other posts from Stack Overflow or by Chris
Published on 2012-12-10T23:02:46Z Indexed on 2012/12/10 23:03 UTC
Read the original article Hit count: 183

Filed under:

mongodb

I've got a database with pre-aggregated metrics similar to the one outlined in this use case: http://docs.mongodb.org/manual/use-cases/pre-aggregated-reports/

I have a daily collection with a subdocument for hour and minute metrics, and a 'metadata.date' entry for midnight on the day it represents. I also have a monthly collection with a day subdocument for each day.

If I want to get an average of a metric over the past eight or so days how can I do that with the aggregation framework? Is the aggregation framework not the right tool for this since it's already pre-aggregated?

Related posts about mongodb

MongoDB usage best practices

as seen on ASP.net Weblogs - Search for 'ASP.net Weblogs'
The project I'm working on uses MongoDB for some stuff so I'm creating some documents to help developers speedup the learning curve and also avoid mistakes and help them write clean & reliable code. This is my first version of it, so I'm pretty sure I will be adding more stuff to it, so stay tuned… >>> More
Errors trying to run MongoDB

as seen on Ask Ubuntu - Search for 'Ask Ubuntu'
I'm running Ubuntu Server 12.04 (32 bit) on an old (1998) computer. Everything's working fine until I try and start MongoDB. somekittens@DLserver01:~$ mongo MongoDB shell version: 2.2.2 connecting to: test Sun Dec 16 22:47:50 Error: couldn't connect to server 127.0.0.1:27017 src/mongo/shell/mongo… >>> More
push new value to mongodb inner array - mongodb/php

as seen on Stack Overflow - Search for 'Stack Overflow'
hi i have this document in mongo: { "_id": ObjectId("4d0b9c7a8b012fe287547157"), "done_by": ["1"] } and i want to add another value to "done_by" field, so my expected document will be:: { "_id": ObjectId("4d0b9c7a8b012fe287547157"), "done_by": ["1","2","3"] } i try this: $conn… >>> More
Write-only collections in MongoDB

as seen on Stack Overflow - Search for 'Stack Overflow'
I'm currently using MongoDB to record application logs, and while I'm quite happy with both the performance and with being able to dump arbitrary structured data into log records, I'm troubled by the mutability of log records once stored. In a traditional database, I would structure the grants for… >>> More
How to install mongoDB on windows?

as seen on Stack Overflow - Search for 'Stack Overflow'
Hi! I am trying to test out mongoDB and see if it is anything for me. I downloaded the 32bit windows version, but have no idea on how to continue from now on. I normally use the WAMP services for developing on my local computer. Can i run mongoDB on Wamp? However, what's the best (easiest!) way… >>> More

Developer IT

Get averages from pre-aggregated reports in mongodb - Developer IT

Get averages from pre-aggregated reports in mongodb

mongodb

Related posts about mongodb

MongoDB usage best practices

Errors trying to run MongoDB

push new value to mongodb inner array - mongodb/php

Write-only collections in MongoDB

How to install mongoDB on windows?

Categories cloud