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.
Hi Tahir- Julianne from Mixpanel Support here.
It should be possible to select the numeric value from the object within a Retention report. For example, in my test project, I sent a property value as 'object_prop':{'my_num':2, 'my_date': '2024-10-30T13:30:25'}, and am able to select 'object_prop > my_num' to break down on the number.
Inline Attachment: image.png
Can you provide an example of the property value that you're sending where you're not able to do so?
My apologies- just realized you had specified filtering with the value. This should also be possible both inline and globally: Inline Attachment: image.png
Julianne B. This is the specific example for my work I had applied filter in global filter tab. But the data doesn't shown The below image is for your reference
Thanks for the response! Are you sure that users meet the specific retention criteria with those filters set? If there aren't any, then the report wouldn't return any data. If that's not the issue, can you submit a ticket via our web form with a link to the specific report? That way we can investigate the exact behavior that you're seeing.
