Handling User Properties in Mixpanel for Retention Analysis
Hi, I'm currently working with Mixpanel and encountering an issue related to user properties. I have stored a user property as an object, which contains two parts:
A numeric value
A date/time value
However, Mixpanel does not support using object-type properties in retention charts, which is limiting my ability to filter based on the numeric part of this property. My goal is to use the numeric value as a filter in retention analysis, but due to the object format, Mixpanel doesn't allow this. Is there an appropriate or recommended way to handle this scenario in Mixpanel? For example:
Should I store the numeric and date/time values as separate properties instead of a single object?
Is there any workaround to extract or reference the numeric part for filtering?
Any guidance would be greatly appreciated.
