Is there a way to set the timezone in a chart widget? The timestamp attribute of the object is a datetime. I have generated a time series, for example, a time series for an electric load profile of a building in NYC with the UTC time offset. However, I am currently working from an office located in Europe, and the time series has shifted to the local timezone of my client. Is there an opportunity to control the timezone offset manually?I am using Mendix Studio Pro Version 9.24.41.Thank you for your support.
asked
Ingo Bernsdorf
1 answers
0
The most reliable solution is to convert the timestamps to the target timezone before sending them to the chart. You can do this by creating a helper entity (typically a non-persistent dataset) that contains an X value for the NYC time (either as a converted DateTime field such as X_NY or as a formatted String label) and a numeric Y value. In a microflow, convert the original UTC DateTime to the America/New_York timezone and store it in this helper object, then use that dataset as the source for the chart. This approach ensures consistent display and correctly handles daylight saving time changes.