Time-Segments-as-a-Service

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.

Try it

Dates are yyyy-mm-dd HH:MM:SS. Hover over any bar to see its bucket below.

Type: -
Year: -
Month: -
Day: -
Hour: -
Minute: -
Second: -

Comments

↪ Replying to

No comments yet.