Mixpanel Community Icon

Creating Custom Date Windows for Data Grouping

·
·

Can I create a property that groups data by a custom date window? e.g. 13:00 - 12:59 in stead of 00:00 to 23:59?

  • Avatar of kapa.ai
    kapa.ai
    APP
    ·
    ·

    Hi Ingmar A., 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

  • Avatar of kapa.ai
    kapa.ai
    APP
    ·
    ·

    Based on the provided knowledge sources, I don't have specific information about creating a property that groups data by a custom date window like 13:00 - 12:59 instead of 00:00 to 23:59 in Mixpanel. However, Mixpanel does offer some flexibility in terms of date and time analysis:1. Mixpanel allows for minute-level granularity in date range selection. You can enable hourly and minute level granularity by using the advanced submenu under the "custom" date range selection. This allows you to select time ranges up to the minute Minute Level Granularity.2. In Insights, Funnel Trends, and Retention Trend reports, you can choose how Mixpanel buckets the time range. For instance, you can select "Hour" as the view to see data in hourly intervals Advanced Date and Time Selectors.3. Mixpanel offers custom bucketing for high-cardinality segments, which might be useful for organizing data into specific time ranges Custom Bucketing.4. For more advanced time-based analysis, Mixpanel's JQL (JavaScript Query Language) provides functions like mixpanel.numeric_bucket() which can be used to segment events over calendar periods when applied to time properties JQL Builtins.While these features offer various ways to analyze data by time, they don't specifically mention the ability to create a custom date window like 13:00 - 12:59. If this specific functionality is crucial for your analysis, you might want to reach out to Mixpanel's support team for more detailed information or potential workarounds.

    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.