Expand my Community achievements bar.

Submissions are now open for the 2026 Adobe Experience Maker Awards

Mark Solution

This conversation has been locked due to inactivity. Please create a new post.

SOLVED

Multicountry Traffic by Hour Analysis

Avatar

Level 1

Hi,

 

For example I am doing an analysis on traffic across 20 countries. Currently our default timezone is set as EST. Is there a good and efficient way for me to do this analysis where 3 PM EST and 6 PM GMT will show up as 3 PM EST and 1 PM EST?

 

I am trying to do this in Big Query or another SQL based environment (so not the UI).

 

Thanks

Rishav

1 Accepted Solution

Avatar

Correct answer by
Level 10

Rishav,

Do not forget that there are many countries with multiple time zones.

Not sure what data is available in your data set, but consider leveraging the time zone dimension if you have it. It's probably the only way to compute the time as per the described scenario.

View solution in original post

1 Reply

Avatar

Correct answer by
Level 10

Rishav,

Do not forget that there are many countries with multiple time zones.

Not sure what data is available in your data set, but consider leveraging the time zone dimension if you have it. It's probably the only way to compute the time as per the described scenario.