Creating a Custom Property for Cash or Amount in MP UI
how can I create a custom property to use cash if the property exists and otherwise use amount using the MP UI custom event creation functionality?
how can I create a custom property to use cash if the property exists and otherwise use amount using the MP UI custom event creation functionality?
Hi Elena M., 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
To create a custom property in Mixpanel that uses the value of the property cash if it exists, and otherwise uses amount, you can use the custom properties feature in the Mixpanel UI. The typical approach is to use a formula with an if-else logic to check if cash is set, and if not, fall back to amount.
Here’s how you can do it:
1. In the Mixpanel UI, click the plus button to the right of the search bar and select Event Property to open the property builder. 2. In the formula bar, use an if-else formula like the following:
```
IF(IS_SET(cash), cash, amount)
LBKS- `IS_SET(cash)` checks if the property cash exists for the event.
- If it does, the formula returns cash; otherwise, it returns amount.
3. Optionally, give your property a name and description.
4. Click **Apply** to use it locally in your report, or **Save** (and optionally **Share**) to make it available globally to your team.
You can see more about creating custom properties and using formulas in the Mixpanel UI in the documentation: [Custom Properties: Calculate new properties on the fly](https://docs.mixpanel.com/docs/features/custom-properties#creating-a-custom-property).
If you need to see available functions while writing your formula, you can press **Ctrl + Space** in the formula bar for suggestions and function descriptions.
> Note: The exact function names (like IS_SET) are not explicitly listed in the provided knowledge sources, but the documentation does mention using Excel-like formulas and if-else logic for these use cases. If you do not see IS_SET, look for similar functions in the formula helper in the UI or in the function list ([reference](https://docs.mixpanel.com/docs/features/custom-properties#functions)).
For more details on creating and saving custom properties, refer to the official documentation: [Creating a Custom Property](https://docs.mixpanel.com/docs/features/custom-properties#creating-a-custom-property).
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.