Is there a way to see when users did events relative to their local time?
Ex. I’m interested in seeing what time of day users are using our mobile app, but it’s unclear to me whether there’s actually a way to see that in Mixpanel, or if I can only ever see the time events happened relative to the project time zone. Based on the timezone documentation I’ve read here, all timestamps are recorded in the project’s time zone, but if that was also the only way to see them in reports the “time of day” breakdown wouldn’t really be accurate to the user’s experience, would it? If I see lots of events showing up at 5AM (PST) but most of the users are on EST, then a 5AM spike wouldn’t actually represent early-morning use.
We do store $timezone as a user property. Perhaps there’s a way to create a custom time property that incorporates the user’s timezone?
Best answer by PeishanView original