Filtering JSON Properties in Mixpanel Reports: Is it Possible?

·Sep 10, 2024 04:12 PM·

Hi all, When I try to filter a "JSON" event property in a report, Mixpanel forces me to drill down into the JSON until I reach a text key that Mixpanel allows to filter. My question is - can I create a filter on the entire JSON property? For example, select all the event that contains the value "X" in the JSON property

11 comments

· Sorted by Oldest

Andrew S.
·
·
How is the property cast? What icon shows next to it in a list when selecting it
Dudi E.
·
·
This is the icon - looks like Mixpanel identifies this as an object
Loading attachments
Andrew S.
·
·
Try recasting it as a string Aa icon
Dudi E.
·
·
How can I do it?
Andrew S.
·
·
Loading attachments
Dudi E.
·
·
I can't select the property, when I try to click on it I drill down into the additional keys inside the object
Dudi E.
·
·
The arrow icon indicates that I can't select it
Loading attachments
Andrew S.
·
·
Can you make a custom property equal to the json object property and set the custom property to be a String?
Dudi E.
·
·
Oh, I understand
Dudi E.
·
·
This works. Thanks a lot!
Andrew S.
·
·
Cool. I don't have any json objects on my end to test with so glad it worked.
🙌1

Andrew S.
·
·
How is the property cast? What icon shows next to it in a list when selecting it
Dudi E.
·
·
This is the icon - looks like Mixpanel identifies this as an object
Loading attachments
Andrew S.
·
·
Try recasting it as a string Aa icon
Dudi E.
·
·
How can I do it?
Andrew S.
·
·
Loading attachments
Dudi E.
·
·
I can't select the property, when I try to click on it I drill down into the additional keys inside the object
Dudi E.
·
·
The arrow icon indicates that I can't select it
Loading attachments
Andrew S.
·
·
Can you make a custom property equal to the json object property and set the custom property to be a String?
Dudi E.
·
·
Oh, I understand
Dudi E.
·
·
This works. Thanks a lot!
Andrew S.
·
·
Cool. I don't have any json objects on my end to test with so glad it worked.
🙌1