3 ms·
Interesting, thanks for your reply. How do you deal with timezones? In our case, for our default dashboard view, we could pre-aggregate everything per hour but
by RedShift1 6y ago
Interesting, thanks for your reply. How do you deal with timezones? In our case, for our default dashboard view, we could pre-aggregate everything per hour but often daily, weekly, monthly denominations are needed, which is where the timezone comes into play. Do you pre-aggregate every possible timezone or just update the views for each user individually?
- tomhoward 6y agoCheers! The time series data is stored as arrays of two-item arrays: [UTC-timestamp-in-ms, value]. We have some aggregated and calculated displays by day/week/month/etc, and these are updated/cached when new data is uploaded, which normally only takes a few seconds or less for each view. Data is shown to end-users in the timezone where the monitoring site is located, which normally is moot as the user looking at the data is located in the same timezone, but where they are not, the timezone is clearly identified on the graph/table.