Using Custom Properties from Event Property Lists in Insights Reports | Mixpanel Community

Using Custom Properties from Event Property Lists in Insights Reports

If I have an event with a property list myList. In the insights report, can I have a custom property that is one of the values in that list? like myList[0]

5 comments

kapa.ai
APP
·
·
Hi Howard A., 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
·
·
Yes, you can create a custom property that references a specific value in a list property like myList[0] in Mixpanel's Insights report. This can be done using the custom properties feature, which allows you to combine existing properties into new properties on the fly.To achieve this, you can use the query function with an index to access a specific element of the list. Here's how you can do it: LBKSquery(myList, 0)LBKSThis custom property formula will return the first element (index 0) of the myList property.This functionality is described in the Mixpanel documentation under the "Query a List with an Index" section Custom Properties: Calculate new properties on the fly. The documentation provides an example of parsing out the first delivery ID in a list property: LBKSquery(properties.DeliveryIDs, 0)LBKSBy creating this custom property, you can then use it in your Insights report like any other property for filtering, breaking down, or in formulas.Remember that custom properties allow you to perform various transformations and calculations on your existing properties, giving you more flexibility in your analysis within Mixpanel.
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.
Howard A.
·
·
kapa.ai Can you link me the relevant documentation please
kapa.ai
APP
·
·
Let me check the knowledge base for you again. One moment! 📚
kapa.ai
APP
·
·
Certainly! The relevant documentation for creating custom properties in Mixpanel, including how to query specific elements from a list property, can be found in the "Custom Properties: Calculate new properties on the fly" section of the Mixpanel documentation.Here's the direct link to the relevant documentation: Custom Properties: Calculate new properties on the flyThis documentation provides detailed information on how to create and use custom properties in Mixpanel, including examples of various functions and operations you can perform, such as querying specific elements from a list 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.