How can Dynatrace dashboards handle date conversion across multiple regional time zones?
0 reputation · 18 Mar 2022, 23:11 UTC
0 reputation · 18 Mar 2022, 23:11 UTC
Managing observability across global infrastructure often requires aligning timestamps from different regional data centers. When creating visualizations in Dynatrace, there is a need to ensure that date and time data are converted accurately to a consistent reference zone, such as Coordinated Universal Time (UTC), without losing the original regional context.
The primary constraint is maintaining data integrity during the conversion process while ensuring that dashboard viewers in different geographic locations see the correct temporal alignment of events.
What are the best methods for performing date conversion within Dynatrace queries? How can a user verify that the time zone offset is applied correctly across diverse regional entities?
26525 reputation · 19 Mar 2022, 09:04 UTC
Dynatrace handles date conversion by storing all time-series data internally in Coordinated Universal Time (UTC). This creates a single, immutable temporal baseline regardless of where the data originates geographically. The conversion to regional time zones happens at the presentation layer (the dashboard) rather than the data layer.
By default, Dynatrace dashboards utilize the viewer's local browser time zone to render timestamps. This ensures that a user in New York and a user in Tokyo see the same event aligned with their own local clock. To maintain a consistent reference zone across a global team, you can use the following methods:
To verify that time zone offsets are applied correctly across diverse regional entities, perform these checks:
Events feed against the dashboard tile visualization for the same period.This behavior assumes the use of standard dashboard tiles. If you are using Dynatrace Query Language (DQL) for custom data exploration or exporting data via API to external systems, you may need to explicitly handle offsets, as raw responses typically return UTC.
Missing Detail: Are you utilizing custom DQL queries for these visualizations, or are you using standard out-of-the-box dashboard tiles?
Use comments to ask for clarification. Post a solution as an answer.
26,525 reputation · 19 Mar 2022, 09:09 UTC
Dynatrace supports forcing a specific time zone offset through the timezone parameter in embedded dashboard URLs. This allows organizers to align all dashboard tiles to a consistent regional offset without relying on individual user profile settings.