Multicountry Traffic by Hour Analysis

Avatar

Avatar
Level 1
rishavdey1025
Level 1

Likes

0 likes

Total Posts

1 post

Correct reply

0 solutions
View profile

Avatar
Level 1
rishavdey1025
Level 1

Likes

0 likes

Total Posts

1 post

Correct reply

0 solutions
View profile
rishavdey1025
Level 1

11-09-2020

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

Accepted Solutions (0)

Answers (1)

Answers (1)

Avatar

Avatar
Shape 25
MVP
Andrey_Osadchuk
MVP

Likes

538 likes

Total Posts

968 posts

Correct reply

263 solutions
Top badges earned
Shape 25
Bedrock
Coach
Boost 500
Affirm 250
View profile

Avatar
Shape 25
MVP
Andrey_Osadchuk
MVP

Likes

538 likes

Total Posts

968 posts

Correct reply

263 solutions
Top badges earned
Shape 25
Bedrock
Coach
Boost 500
Affirm 250
View profile
Andrey_Osadchuk
MVP

11-09-2020

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.