Duration 2 wks
Bucket size: 1 hr
Let's say we want to get an average count for each time of the day bucket (1 hour) for last 2 wks.
The chart should have 24 buckets, for each bucket is an average count of all the documents with timestamp in that time of the day for the last 2 weeks.
Any one have cool idea of how to tackle this?