How is Daylight Saving 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.

Example 1:

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 8^th 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.

Example 2:

Consider running a report with 24-hour intervals for seven days. 

Mar 8, 2026 12:00 AM – Mar 9, 2026 12:00 AM – DST occurs, the day is 23 hours, and one hour is skipped (2:00 AM–2:59 AM does not exist).
Mar 9, 2026 12:00 AM – Mar 10, 2026 12:00 AM – New interval starts at the previous interval’s end time.
Mar 10, 2026 12:00 AM – Mar 11, 2026 12:00 AM
Mar 11, 2026 12:00 AM – Mar 12, 2026 12:00 AM
Mar 12, 2026 12:00 AM – Mar 13, 2026 12:00 AM
Mar 13, 2026 12:00 AM – Mar 14, 2026 12:00 AM
Mar 14, 2026 12:00 AM – Mar 15, 2026 12:00 AM

The actual week of Mar 8–14 ends at 11:59 PM on Mar 14. As DST shifted the time forward by one hour, the first day had only 23 hours. To maintain the 24-hour interval, the system continues generating subsequent intervals based on the previous interval’s end time. Unlike the fall DST change, no additional interval is added because one hour is lost during the time shift.