Timestream data visualised incorrectly on Quicksight

[duncan]

Hello @venieran , welcome to the QuickSight community!

It might be helpful to try the calculated fields that are described in this blog:

Time Zone Adjustments

Most databases (including SPICE) store timestamps in UTC time. If you want to be able to dynamically adjust the time zone of the data displayed in your visuals for different users, we can do this using parameters and calculated fields. This technique will work both for if you want to allow Readers to change the time zone themselves (using a Control), or if you want to specify the time zone programmatically via the URL or via the JS SDK (for instance if you are embedding a dashboard in your appli…

This was created before custom time zones were available in QuickSight.

Let me know if this helps/works