Logical error with period/bucket calculations about pulse HOT 1 CLOSED

Hi @ercsctt,

This is intentional. Buckets hold 1/60th of the window they belong to.

60 is somewhat arbitrary, but there are two reasons we chose it:

• 60 points looks pretty good on the graphs.
• For the "leaderboard" cards, we aggregate multiple buckets together to fill as much of the window as possible, and then combine that with raw data from the pulse_entries table to fill in the oldest part of the window where the oldest bucket would fall partially inside and outside the window. This allows us to do rolling window aggregation down to the second. I.e. we can show windows like "the past hour" rather than tumbling windows like "10am - 11am". 60 buckets seems like a good balance that keeps the number of raw entries queried to a minimum without creating too many buckets.

I explained the approach in more detail here: https://www.youtube.com/watch?v=9cliEswA8CA&pp=ygUYbGFyYXZlbCB3b3JsZHdpZGUgbWVldHVw

from pulse.