jstanden / cerb

Cerb is a fully customizable, web-based platform for enterprise communication and process automation. Create high volume shared inboxes. Integrate with any API-based service and automate nearly any repetitive digital workflow using the specialized KATA language and browser-based coding tools. Production: https://github.com/cerb/cerb-release/
https://cerb.ai/
Other
80 stars 38 forks source link

[Metrics] In metrics data queries, roll up hourly bins for `day` period 1mo or less if a `timezone` is used #1706

Open jstanden opened 1 year ago

jstanden commented 1 year ago

Right now we store all day bins in UTC time. This is fine for weeks/months/years.

However, on a shorter timescale like 2 weeks, UTC days can shift many hours from the desired timezone and distort reporting.

If we expand retention on hourly metrics to 31 days, then anything shorter than that at day interval with an explicit timezone could be generated dynamically using hour samples to account for the timezone.