Combine Height, Width, and Depth into a Single Property Format
I need to combine some properties into a single property. The properties are: Height, Width and Depth. the output format i want is "Height Width 'D'Depth".
I need to combine some properties into a single property. The properties are: Height, Width and Depth. the output format i want is "Height Width 'D'Depth".
Hi Chris S., 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
Based on the knowledge sources, you can combine your Height, Width, and Depth properties into a single property using Custom Properties in Mixpanel.
Here's how to create this custom property:
1. In your report, click on the formula bar to start defining your custom property 2. Use the following formula to combine your properties in the format you specified:
```
Height + " " + Width + " D" + Depth
LBKSThis formula uses the `+` operator for string concatenation. According to the [Custom Properties documentation](https://docs.mixpanel.com/docs/features/custom-properties#numeric-operators), the addition operator can be used to create string concatenation.
**Important notes:**
- When writing your formula, you can type **period (.)** to open the menu for choosing event/profile properties to add to your custom property definition
- Press **Ctrl + Space** to see a list of all available functions
- Click **Apply** to use the custom property locally in your report first
- Once you've verified it works correctly, click **Save** to make it available for reuse in other reports and share it with your team
The resulting property will display values in the format you requested, such as "10 20 D30" (assuming Height=10, Width=20, Depth=30).
You can learn more about creating custom properties in the [Custom Properties documentation](https://docs.mixpanel.com/docs/features/custom-properties).
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.