Solved

Normalized time zone

  • 15 August 2022
  • 2 replies
  • 47 views

Badge

Hi,

 

So, we have customers from all over and I wanted to know if it is possible to normalize hours of day?

Meaning, I’d like to see the user time zone rather than the account time zone so that users from Germany 4PM would join users from USA 4PM.

Regards and thanks!

icon

Best answer by Saish Redkar 15 August 2022, 22:44

View original

2 replies

Userlevel 7
Badge +10

Hey @Omriko 

Don’t think that’s possible currently in any of the charts.

The general behavior is that the events will be plotted by the client_event timestamp in UTC time or the selected timezone of your project.

Amplitude recently launched the Event Hour of Day / Day of Week properties wherein you can use these properties to selectively filter on specific days/hour of the event occurrence ( not sure if this is available to all or just paid customers )

They have also launched the capability wherein you can select your timezone directly from the date picker widget instead of toggling this in the project settings.

If you have access to this and your use case is to understand the most common hour of day as per timezones you could try the following :

  • query any active event and group by event hour of day
  • select the apt time zone and visualize the event volume by event hour of day for that timezone
  • additionally you can also filter on any geo/country property for added accuracy

e.g this chart - https://analytics.amplitude.com/demo/chart/new/u08nngh

this one kinda tells that 6 am NYC time seems the most active time for users where country property is USA.

Hope this helps.

Badge

Thank you for the answer!

This will works for us for now :)

Reply