Replacing Not Set Values in Mixpanel Reports: Solutions Needed

Hi Team, Is there any way to replace not set in mixpanel report with other value?

· Sorted by Oldest

Andrew S.
·
·
You can create a custom property that replaces the not set with another value
Andrew S.
·
·
Example. https://mixpanelcommunity.slack.com/archives/C02RUV27S3V/p1724325963888699
Sonia
·
·
I tried custom properties but in mixpanel we can replace undefined with other values but not set values
Andrew S.
·
·
My example formula in the comments used IF to replace when undefined (ie not set) with a value. Eg in that case the referrer was not set bc the traffic was Direct
Andrew S.
·
·
Change it to UNDEFINED https://mixpanelcommunity.slack.com/files/U04B2K0S0PP/F07JEKXA64R/screenshot_2024-08-22_at_7.59.12___am.png
Sonia
·
·
Thank you Andrew S.
Andrew S.
·
·
👍

Andrew S.
·
·
You can create a custom property that replaces the not set with another value
Andrew S.
·
·
Example. https://mixpanelcommunity.slack.com/archives/C02RUV27S3V/p1724325963888699
Sonia
·
·
I tried custom properties but in mixpanel we can replace undefined with other values but not set values
Andrew S.
·
·
My example formula in the comments used IF to replace when undefined (ie not set) with a value. Eg in that case the referrer was not set bc the traffic was Direct
Andrew S.
·
·
Change it to UNDEFINED https://mixpanelcommunity.slack.com/files/U04B2K0S0PP/F07JEKXA64R/screenshot_2024-08-22_at_7.59.12___am.png
Sonia
·
·
Thank you Andrew S.
Andrew S.
·
·
👍