Analyzing Date Range Properties in Report Feature

Hi Sharon L., 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> 👋

Yes, Mixpanel supports date properties and allows you to analyze them in reports. You can send date properties to Mixpanel and then use them in various ways: 1. Date Property Support: Mixpanel supports "Date" as one of its five primary data types for properties. This is specifically used to capture both date and/or timestamp information, such as "Jun 20, 2009 14:20:30" Build Your Tracking Strategy.2. Date Range Selection in Reports: When analyzing your data, you can select specific date ranges in reports using the date range selector. This allows you to view data for custom time periods, including options like "Last", "Fixed", and "Since" Reports Overview.3. Typecasting: If your date property was sent as a different data type (like a number for a unix timestamp), you can use Mixpanel's typecasting feature to convert it to a date property for analysis Reports Overview.4. Computing Date Differences: You can even use custom properties to compute the difference between two date properties or between a date property and the current date. For example, you could transform a "DateofBirth" property into "age" or a "Created" property into "days active since registration" Custom Properties.When working with date properties in reports, you can filter, breakdown, and analyze your data based on these date values to gain insights about user behavior over specific time periods.

ℹ️ Tip: Mention @kapa.ai in the thread for follow-ups or DM the app for 1-to-1 help.

Let me check the knowledge base for you again. One moment! 📚

No, if you skip sending a boolean property under certain circumstances, it does not count as "value = false" in Mixpanel reports. Instead, it will be treated as "undefined" or "(not set)" in the UI.According to the documentation: 1. When a property is not sent with an event, it's considered "undefined" in Mixpanel. Undefined values appear when events being measured in a query do not contain the property used for breakdown. These undefined values are parsed as "(not set)" in the UI Data Type Documentation.2. This is different from explicitly sending a property with a "null" value, which represents the intentional absence of any object value. Both null and undefined values appear as "(not set)" in the UI, though null values will show as <null> or null when viewing raw data Data Type Documentation.3. For boolean properties specifically, Mixpanel recommends that "if certain property values (eg null, N/A, "" - empty string) are essentially considered unavailable, Mixpanel generally recommends that for those instances the property should not be sent with the event or user profile" Tracking Strategy.When analyzing in reports, you can use the "defined()" function to specifically filter for events where a property is set or not set. For example, defined(properties["My Prop"]) returns true if the property has any value, otherwise false. This is equivalent to the "is set" filter in the UI Segmentation Expressions.If you need to specifically analyze cases where a boolean property is false versus not set at all, you'll need to ensure you're explicitly sending "false" for the false cases rather than omitting the property.

ℹ️ Tip: Mention @kapa.ai in the thread for follow-ups or DM the app for 1-to-1 help.

Let me check the knowledge base for you again. One moment! 📚

You can display the $duration property in hh:mm:ss format instead of seconds by using Mixpanel's chart customization features and formula calculations. Here's how to do it:

Mixpanel's Chart Customization feature allows you to control how metrics are displayed, including their units and formatting: 1. In your report, locate the metric block containing the $duration property 2. Find the unit configuration in the bottom left of the metric block 3. You can customize the unit display for this metric Chart Customization

For more precise control, you can use formulas to convert the seconds into hours, minutes, and seconds format: 1. Click the Metrics button, then select "Formula" 2. Create a formula that converts seconds to the desired format 3. For example, if your duration is in metric A, you could create formulas to extract hours, minutes and secondsUnfortunately, the knowledge sources don't provide a direct formula for converting seconds to hh:mm:ss format in Mixpanel. However, you can use formulas to convert seconds to minutes by dividing by 60, as shown in this example for session duration: LBKS// To convert session duration from seconds to minutes Session Duration (seconds) / 60LBKSThis approach is mentioned in the Sessions FAQ: "To change it from seconds to minutes, you can use our formula and divide it by 60" Sessions FAQ.For a complete hh:mm:ss format, you might need to create multiple metrics and combine them in your visualization or export the data for further formatting.Remember that the $duration property is automatically appended to events to capture elapsed time between a time_event and a track call in Mixpanel SDKs.I hope this helps! Let me know if you need more specific guidance on implementing this in your Mixpanel reports.

ℹ️ Tip: Mention @kapa.ai in the thread for follow-ups or DM the app for 1-to-1 help.