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: LBKSHeight + " " + Width + " D" + DepthLBKSThis formula uses the + operator for string concatenation. According to the Custom Properties documentation, 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 teamThe 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.
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.
