You are doing calculations with dates and times, or displaying them in charts, but:
Root cause: Dates and times are stored using different time zones, but some or all of those time zones aren’t taken into account when doing calculations (i.e., the problem is inconsistent data).
Steps to take:
To fix this problem you’ll need answers to these questions:
Dec 1, 2019 00:00:00Z00
Dec 1, 2019
Once you have these answers, look for cases like these:
Once you think you have identified a problem, drill down to understand exactly what time zone conversion is causing the underlying problem. For example, suppose you’re looking at a time series with daily values; if your error is happening with weekly totals, you can:
Root cause: Wrong numbers in questions or charts can be caused by a mis-match in the time zone being used by Metabase and the time zone being used by the data warehouse.
Root cause: We don’t currently apply a reporting time zone to the results of SQL queries.
Root cause: You are grouping by a date (rather than by a time) that lacks a time zone.
Root cause: You’re comparing or doing arithmetic on two dates where one has an explicit time zone and one doesn’t.
Did this article help you?
Thanks for your feedback!