Time-series data is often pre-aggregated into buckets - one row per year, per month, per day and so on. To total everything between two datetimes, you want to cover that range with as few buckets as possible: whole years where you can, then whole months, days, hours, minutes and seconds to fill in the gaps at either end.
This mini-app works out those buckets for any range, and shows which size each one is. The name was an in-joke among the developers.
Dates are yyyy-mm-dd HH:MM:SS. Hover over any bar to see its bucket below.
Comments
No comments yet.