Amazon QuickSight is excited to announce the launch of Custom Time Zone feature. This feature aims to improve the experience for customers dealing with data spanning diverse geographic regions, offering QuickSight authors enhanced flexibility in interpreting and manipulating data with time zones customized to their preferences, beyond the constraints of UTC. Before this feature, QuickSight lacked time zone awareness. Customers have to explicitly define time zone conversions through offset calculated field for individual data fields from different sources. With the introduction of out-of-the-box support for Custom Time Zone, dashboard authors can effortlessly select their desired time zone with a single click. QuickSight will seamlessly convert all time-aware visual dimensions, aggregated measures, calculated fields, filters, and parameters to the chosen time zone during query execution, in a timely manner. Furthermore, Daylight Saving Time adjustments are automatically applied, eliminating the need for workarounds that may inaccurately handle historical dates. For further details, visit here.
Source:: Amazon AWS