Fun problem: Average of the bucketed count for time of the day in time range

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?

This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.