Troubleshooting Your Dataview Formula for Variable Capture

What is wrong in my dataview formula ? im trying to capture 4 variable + the case where its undefined or not set IFS( "BRAND" in site_info__brand and "COUNTRY" in site_info__country, "BRAND COUNTRY", "BRAND" in site_info__asset_brand and "COUNTRY" in site_info__asset_country, "BRAND COUNTRY", "not set" in site_info__brand or "not set" in site_info__country, "not set BRAND COUNTRY Event", "not set" in site_info__asset_brand or "not set" in site_info__asset_country, "not set BRAND COUNTRY Event", UNDEFINED(site_info__brand) or UNDEFINED(site_info__country), "not set BRAND COUNTRY Event", UNDEFINED(site_info__asset_brand) or UNDEFINED(site_info__asset_country), "not set BRAND COUNTRY Event" )

2 comments

· Sorted by Oldest

kapa.ai
APP
·
·
Hi Sebastien C., 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> 👋
Feel free to ask a follow-up question once I've answered by mentioning me with @kapa.ai
kapa.ai
APP
·
·
Your formula has a few issues based on Mixpanel's custom property syntax and available functions: 1. Use of "not set": In Mixpanel, "not set" is not a literal string value you should check for. Instead, properties that are not set will appear as undefined (or sometimes null). You should use the defined() function to check if a property exists, or compare directly to undefined if you want to capture cases where a property is not set Custom Properties Reference Supported Properties Data Type.2. UNDEFINED() function: There is no UNDEFINED() function in Mixpanel's custom property formula language. Instead, you should use defined(property) to check if a property is set, or compare the property directly to undefined.3. Use of in operator: The in operator checks if the first argument is contained in the second. If you want to check if a property equals a value, use ==. If you want to check if a property is in a list, use A in ["value1", "value2"].
How to Fix
Here’s a corrected version of your formula, assuming you want to: - Return "BRAND COUNTRY" if both brand and country are set (and not undefined) - Return "not set BRAND COUNTRY Event" if any of the properties are not set plaintext ifs( defined(site_info__brand) and defined(site_info__country), "BRAND COUNTRY", defined(site_info__asset_brand) and defined(site_info__asset_country), "BRAND COUNTRY", not defined(site_info__brand) or not defined(site_info__country), "not set BRAND COUNTRY Event", not defined(site_info__asset_brand) or not defined(site_info__asset_country), "not set BRAND COUNTRY Event" )LBKS- The defined() function checks if a property exists. - The not operator negates the condition. - You do not need to check for "not set" as a string, nor use a non-existent UNDEFINED() function.Note: If you want to distinguish between empty strings and undefined, you may need to add additional checks for site_info__brand == "" or similar.For more on these functions and operators, see the official documentation: Custom Properties Reference, Supported Properties Data Type.
kapa.ai is still learning and improving, please let me know how I did by reacting below.
ℹ️ Tip: Mention @kapa.ai in the thread for follow-ups or DM the app for 1-to-1 help.

kapa.ai
APP
·
·
Hi Sebastien C., 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> 👋
Feel free to ask a follow-up question once I've answered by mentioning me with @kapa.ai
kapa.ai
APP
·
·
Your formula has a few issues based on Mixpanel's custom property syntax and available functions: 1. Use of "not set": In Mixpanel, "not set" is not a literal string value you should check for. Instead, properties that are not set will appear as undefined (or sometimes null). You should use the defined() function to check if a property exists, or compare directly to undefined if you want to capture cases where a property is not set Custom Properties Reference Supported Properties Data Type.2. UNDEFINED() function: There is no UNDEFINED() function in Mixpanel's custom property formula language. Instead, you should use defined(property) to check if a property is set, or compare the property directly to undefined.3. Use of in operator: The in operator checks if the first argument is contained in the second. If you want to check if a property equals a value, use ==. If you want to check if a property is in a list, use A in ["value1", "value2"].
How to Fix
Here’s a corrected version of your formula, assuming you want to: - Return "BRAND COUNTRY" if both brand and country are set (and not undefined) - Return "not set BRAND COUNTRY Event" if any of the properties are not set plaintext ifs( defined(site_info__brand) and defined(site_info__country), "BRAND COUNTRY", defined(site_info__asset_brand) and defined(site_info__asset_country), "BRAND COUNTRY", not defined(site_info__brand) or not defined(site_info__country), "not set BRAND COUNTRY Event", not defined(site_info__asset_brand) or not defined(site_info__asset_country), "not set BRAND COUNTRY Event" )LBKS- The defined() function checks if a property exists. - The not operator negates the condition. - You do not need to check for "not set" as a string, nor use a non-existent UNDEFINED() function.Note: If you want to distinguish between empty strings and undefined, you may need to add additional checks for site_info__brand == "" or similar.For more on these functions and operators, see the official documentation: Custom Properties Reference, Supported Properties Data Type.
kapa.ai is still learning and improving, please let me know how I did by reacting below.
ℹ️ Tip: Mention @kapa.ai in the thread for follow-ups or DM the app for 1-to-1 help.

2 comments

2 comments

How to Fix

How to Fix