Can we create a custom event by adding or multiplying two properties from different or same event?
Hi Shivank D., 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
Yes, you can create a custom event by combining properties from different or the same events using Mixpanel's Custom Properties feature. This feature allows you to combine existing properties into new properties on the fly, using a simple Excel-like formula language. To create a custom property, click the plus button to the right of the search bar, then select Event Property or User Property to open the property builder. Optionally give your property a name and click into the formula bar to start defining it. When writing your formula, click Ctrl + Space to see a list of all the available functions and their descriptions. Click period (.) to search for event or user profile properties to add to the formula.Custom properties are local to the report by default, when you select Apply. To save the custom property permanently for use in other reports and to make it usable by other project members, click Save. Also, note that the formula used to compose your custom property can't be longer than 20,000 characters.For more information, you can refer to the Mixpanel documentation on Custom Properties.
kapa.ai is still learning and improving, please let me know how I did by reacting below
⤵️ Hint: Mention @kapa.ai in the thread for follow-ups.
kapa.ai I want to sum to properties and create a separate rate event. How can I do so?
Let me check the knowledge base for you again. One moment! 📚
To create a new event by summing two properties, you can use Mixpanel's Custom Properties feature. Here are the steps:1. Click the plus button to the right of the search bar, then select Event Property or User Property to open the property builder.
2. Give your property a name and click into the formula bar to start defining it.
3. In the formula bar, you can write a formula to sum the two properties. For example, if you have two properties property1
and property2
, your formula could be property1 + property2
.
4. After defining the formula, click Apply to use the custom property in your current report. If you want to save the custom property permanently for use in other reports and to make it usable by other project members, click Save.Please note that the formula used to compose your custom property can't be longer than 20,000 characters.For more information, you can refer to the Mixpanel documentation on Custom Properties.However, please note that creating a separate event based on the result of this sum is not directly supported. Custom properties allow you to create new properties, not events. If you want to create a new event based on the result of this sum, you might need to do this in your application code when sending events to Mixpanel.
kapa.ai is still learning and improving, please let me know how I did by reacting below
⤵️ Hint: Mention @kapa.ai in the thread for follow-ups.
kapa.ai properties are in list format?
Let me check the knowledge base for you again. One moment! 📚
Yes, Mixpanel supports properties in list format. A list of values can be sent as a JSON array. For example, Favourite Genres = ["Folk","Alternative"] or Favourite Numbers = [1,5,10.0]. There are some limits to a List property: - Event Property = 8KB - User Profile Property = 256KBEach item in a list would be further limited by their data type's limits. For example, a list of strings would be limited by 255 bytes per string. Mixpanel lists are not ordered (i.e., the position of values in a list are not significant in Mixpanel reports) and are useful for grouping or analyzing similar values across events.For more details, you can refer to the Mixpanel documentation on Property Reference.
kapa.ai is still learning and improving, please let me know how I did by reacting below
⤵️ Hint: Mention @kapa.ai in the thread for follow-ups.
kapa.ai I want to sum two properties and create a separate event(properties are in list format). How can I do so?
Let me check the knowledge base for you again. One moment! 📚
Creating a new event by summing two properties that are in list format is not directly supported by Mixpanel's Custom Properties feature. Custom properties allow you to create new properties, not events, and they work with simple Excel-like formulas, not with list operations.However, you can handle this in your application code when sending events to Mixpanel. You would need to write code that sums the elements of the two lists and then sends this sum as a property of a new event to Mixpanel.Here's a general idea of how you might do this in Python:``` python
list1 = [1, 2, 3] list2 = [4, 5, 6]# Sum the elements of the two lists sum_list = [a + b for a, b in zip(list1, list2)]# Send a new event to Mixpanel with the sum as a property mixpanel.track(user_id, 'New Event', { 'Sum Property': sum_list })```Please note that this is a general idea and the actual implementation might differ based on your application's programming language and the Mixpanel library you're using.For more information on how to send events to Mixpanel, you can refer to the Mixpanel documentation on sending events.
kapa.ai is still learning and improving, please let me know how I did by reacting below
⤵️ Hint: Mention @kapa.ai in the thread for follow-ups.