Timeline chart subtracts 4 hours for any given datetime

[aliuysal]

Hi all,

The newly introduced timeline chart in Looker Studio shows time in the x-axis after subtracting 4 hours from any given datetime value.

For instance;

1. Timezone = Eastern Time (GMT-4)

Start Time = 05/17/2024 5:00:19 AM

End Time = 05/17/2024 5:16:18 AM

The x-axis of the timeline chart starts at 1 AM.

1. Timezone = Coordinated Universal Time (GMT)

Start Time = 05/17/2024 9:00:19 AM

End Time = 05/17/2024 9:16:18 AM

The x-axis of the timeline chart starts at 5 AM.

Could this be a bug or am I missing something here? Thank you.

[cossa]

Yes, @aliuysal  

It's a nice Chart but useless with the difference in time. The information said that the looker studio takes the time zone where the data is allocated... but not all the Viewers are in the same location... 

Please let us know how to adjust to the real 

All the best,

Cristobal

[cossa]

I found one solution (not complete solucion) 

DATETIME_ADD(DATETIME_Departure, INTERVAL 4 HOUR) But when the user put his mouse on top its going to show the wrong DATETIME