How is Daylight Savings Time (DST) handled?
When loading a view or running an export, time intervals are divided into even time chunks (granularity). When a report includes a time change, the time shift impacts the start/end time of the intervals within the report.
For example, consider running a report with 24-hour intervals for seven days.
Nov 3, 2024 12:00 AM – Nov 3, 2024 11:00 PM – DST Occurs, the day is 25 hours, and the end time shifts back to 11.
Nov 3, 2024 11:00 PM – Nov 4, 2024 11:00 PM – New interval starts at the previous interval’s end time.
Nov 4, 2024 11:00 PM – Nov 5, 2024 11:00 PM
Nov 5, 2024 11:00 PM – Nov 6, 2024 11:00 PM
Nov 6, 2024 11:00 PM – Nov 7, 2024 11:00 PM
Nov 7, 2024 11:00 PM – Nov 8, 2024 11:00 PM
Nov 8, 2024 11:00 PM – Nov 9, 2024 11:00 PM
Nov 9, 2024 11:00 PM – Nov 10, 2024 11:00 PM – Additional 8th interval added due to DST time shift.
The actual week of Nov 3–9 ends at 11:59 PM on Nov 9. As DST shifted the time backward by one hour, the first day had 25 hours. To maintain the 24-hour interval, the subsequent intervals are adjusted backward by one hour. Due to the DST time shift, the report added an eighth interval to account for that extra hour.