Multicountry Traffic by Hour Analysis | Community
Skip to main content
R
rishavdey1025
September 11, 2020
Solved

Multicountry Traffic by Hour Analysis

  • September 11, 2020
  • 1 reply
  • 928 views

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

This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.
Best answer by Andrey_Osadchuk

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.

1 reply

Andrey_Osadchuk
Andrey_OsadchukAccepted solution
Level 10
September 11, 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.

Terms & ConditionsAccessibility statement

Loading footer...