Is it possible to create a custom event property in Mixpanel on existing events that calculates if the time event property is within working hours for example between 0800 1800 UK timezone?
Hi Tim V., Please stand by as I search the Mixpanel knowledge base for an AI-powered answer. I normally take about 15 seconds or so. In case AI cannot answer your question, feel free to reach out to Mixpanel support at mixpanel.com/get-support. If you have follow-up questions for this thread, please tag me again with your question: @kapa.ai <follow-up question> 👋
Feel free to ask a follow-up question once I've answered by mentioning me with @kapa.ai
Based on the information in the knowledge sources, Mixpanel allows you to create custom properties using a formula language, and you can use date/time functions to compute differences or transform date properties (e.g., calculating days between two dates or using the TODAY() function) Custom Properties: Common Use Cases. However, the documentation does not explicitly mention the ability to extract the hour from a timestamp or to directly compare event times against specific hour ranges (such as 08::00–18::00 in a specific timezone) within the custom property formula editor.Mixpanel stores all event timestamps in UTC and outputs results in your project’s selected timezone. You can set your project timezone to UK time, and Mixpanel will display event times accordingly in reports Manage Timezones for Projects. However, there is no explicit documentation confirming that you can create a custom event property that checks if an event’s time falls within a specific hour range (like working hours) using the built-in formula editor.In summary: The knowledge sources do not explicitly confirm that you can create a custom event property to check if an event occurred within working hours (e.g., 08::00–18::00 UK time) using Mixpanel’s custom property formula editor. You may be able to achieve this with more advanced data processing outside Mixpanel or by using JQL (which is in maintenance mode), but this is not documented as a built-in feature for custom properties.If you need this functionality, you may want to consider preprocessing your data before ingestion or using external tools for this specific calculation.
kapa.ai is still learning and improving, please let me know how I did by reacting below.
ℹ️ Tip: Mention @kapa.ai in the thread for follow-ups or DM the app for 1-to-1 help.