Formula for Conditional Value Selection in Custom Properties

JH. K. · 2025-08-07T04:29:47.839Z

What is the calculation formula for taking the value A if the value A exists in the Custom Property and taking the value B if the value A does not exist?

Formula for Conditional Value Selection in Custom Properties | Mixpanel Community

6 comments

· Sorted by Oldest

kapa.ai
APP
·
·
Please stand by JH. K. as I search the knowledge base. I normally take about 15 seconds or so. 👋
Feel free to ask a follow-up question once I've answered by mentioning me with @kapa.ai
kapa.ai
APP
·
·
To achieve this in Mixpanel's Custom Properties, you can use the defined() function to check if value A exists. If A is defined, use A; otherwise, use B. The formula would look like this: LBKSif(defined(A), A, B)LBKSThis formula evaluates whether A is defined (exists). If it is, it returns A; if not, it returns B. This approach is explicitly documented in the custom properties reference for Mixpanel formulas Docs / Features / Custom Properties: Functions.
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.
JH. K.
·
·
what ifs?
JH. K.
·
·
kapa.ai How do I set different periods for the dashboard and the report?
kapa.ai
APP
·
·
Let me check the knowledge base for you again. One moment! 📚
kapa.ai
APP
·
·
In Mixpanel, you can set different date ranges (periods) for a dashboard (Board) and for individual reports. Here’s how it works: - Board-wide Date Range: When you apply a date range on a Board, it temporarily updates the data displayed for all reports on that Board. However, this does not change the saved date range of the individual reports themselves. - Individual Report Date Range: If you access a report directly (not from the Board), it will display data based on the report’s original saved date range and filters.So, the Board can show data for one period, while the underlying report retains its own period setting. This allows you to explore data with different timeframes on the Board without altering the original report configuration. If you want to make permanent changes to the Board filters, you can use Pinned Filters, but the default Board date range does not override the report’s own date range settings Step 5: Board-wide Date Ranges and Filters.Summary: - Board date range = temporary, for Board view only - Report date range = permanent, for the report itselfThis lets you view the same report with different periods depending on where you access it.
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
·
·
Please stand by JH. K. as I search the knowledge base. I normally take about 15 seconds or so. 👋
Feel free to ask a follow-up question once I've answered by mentioning me with @kapa.ai
kapa.ai
APP
·
·
To achieve this in Mixpanel's Custom Properties, you can use the defined() function to check if value A exists. If A is defined, use A; otherwise, use B. The formula would look like this: LBKSif(defined(A), A, B)LBKSThis formula evaluates whether A is defined (exists). If it is, it returns A; if not, it returns B. This approach is explicitly documented in the custom properties reference for Mixpanel formulas Docs / Features / Custom Properties: Functions.
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.
JH. K.
·
·
what ifs?
JH. K.
·
·
kapa.ai How do I set different periods for the dashboard and the report?
kapa.ai
APP
·
·
Let me check the knowledge base for you again. One moment! 📚
kapa.ai
APP
·
·
In Mixpanel, you can set different date ranges (periods) for a dashboard (Board) and for individual reports. Here’s how it works: - Board-wide Date Range: When you apply a date range on a Board, it temporarily updates the data displayed for all reports on that Board. However, this does not change the saved date range of the individual reports themselves. - Individual Report Date Range: If you access a report directly (not from the Board), it will display data based on the report’s original saved date range and filters.So, the Board can show data for one period, while the underlying report retains its own period setting. This allows you to explore data with different timeframes on the Board without altering the original report configuration. If you want to make permanent changes to the Board filters, you can use Pinned Filters, but the default Board date range does not override the report’s own date range settings Step 5: Board-wide Date Ranges and Filters.Summary: - Board date range = temporary, for Board view only - Report date range = permanent, for the report itselfThis lets you view the same report with different periods depending on where you access it.
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.