Convert ISO8601 Timestamps to Europe/Berlin Time (Timestream)

[htlraw]

Hi everyone,

I’m using an AWS Timestream dataset in QuickSight, which contains ISO8601 timestamps. According to this documentation, custom time zones are not supported for Timestream.

I need to convert these timestamps to the Europe/Berlin time zone and use them in my analysis. How can I achieve this within QuickSight?

I have already tried to insert a calculated field (time-eu-berlin). But it is converted back to UTC in my analysis?

parseDate(formatDate({time},"yyyy-MM-dd HH:mm:ss",'Europe/Berlin'), "yyyy-MM-dd HH:mm:ss")

Dataset:

Analysis shows this:

[Xclipse]

Hi @htlraw

Welcome to the QuickSight community!

Your calculation looks correct. Please add it at the dataset level. I tested your calculation by creating it in the dataset, and it works fine in the analysis since the calculation is converted to the desired time and stored in SPICE memory.

Different date formats are supported based on the type of dataset used. check the table to see details of supported date formats. refer this parseDate