can I count the average number of characters in a property

Hi Tobias, 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> 👋

Yes, you can count the average number of characters in a property in Mixpanel using Custom Properties. This feature allows you to create calculated properties on the fly using various functions.To calculate the average number of characters in a property, you can use the len() function combined with the avg() function. Here's how you would approach this: 1. First, use the len() function to get the length of each string property 2. Then use the avg() function to calculate the average of those lengthsThe len() function returns the length of a string or list, as mentioned in the documentation: Custom Properties FunctionsYou can create a custom property by: 1. Clicking the plus button to the right of the search bar 2. Selecting Event Property or User Property to open the property builder 3. Giving your property a name 4. Writing your formula using the available functions 5. Applying or saving the custom propertyFor example, if you wanted to calculate the average length of a property called "message_text" across all events, you could create a custom property that uses the len() function on each message, and then use Mixpanel's aggregation functions to calculate the average.Remember that Mixpanel supports five data types for properties (String, Numeric, Boolean, Date and List), and choosing the appropriate data type enables richer analysis, including aggregations for numeric data types.Custom Properties Creation

ℹ️ Tip: Mention @kapa.ai in the thread for follow-ups or DM the app for 1-to-1 help.

Let me check the knowledge base for you again. One moment! 📚

I see you're encountering an "unknown function" error when trying to use avg(). This suggests you might be using it in a context where it's not supported or using incorrect syntax.Based on the knowledge sources, the avg() function is primarily available in specific contexts within Mixpanel: 1. In JQL (JavaScript Query Language) as mixpanel.reducer.avg() - This is used for computing the average of a numeric collection in JQL queries: LBKSfunction main() { return Events({ from_date: "2016-01-01", to_date: "2016-06-01", event_selectors: [{event:"pageview"}] }) .reduce(mixpanel.reducer.avg("properties.load_time_ms")); }LBKSJQL Builtins2. As a data function in Mixpanel reports - The "Average per user" is mentioned as one of the data functions available in the query builder inside reports. Data functions explainedIf you're trying to use avg() in a custom property formula, it might not be directly available there. For custom properties, you might need to use a different approach or syntax.Could you provide more context about where you're trying to use the avg() function? This would help me give you more specific guidance on the correct syntax or alternative approaches.

ℹ️ Tip: Mention @kapa.ai in the thread for follow-ups or DM the app for 1-to-1 help.

Let me check the knowledge base for you again. One moment! 📚

To access the length of strings embedded in an array property in Mixpanel, you can use custom properties with specific functions designed to work with lists and strings.Based on the knowledge sources, Mixpanel supports List data types which are "meant for capturing an array / collection of similar or related values" Property Data Types.For accessing elements within a list and then getting their length, you can use: 1. The index notation to access a specific element in the list 2. The SPLIT function to parse parts of a string 3. Custom properties to create transformationsHere's how you can access a specific element in a list and potentially get its length: LBKS// To access the first element in a list property list_property[0]LBKSAs shown in the documentation, you can query a list with an index: "Let's say you have a list of recommendations as a property, and you'd like to parse out the first recommendation as another string property. You can parse out the first delivery ID in a list property with several DeliveryIDs" Custom PropertiesOnce you've accessed the string element from your array, you can then use string functions to get its length.If you're trying to do this in JQL (JavaScript Query Language), you have more flexibility. You could use JavaScript functions directly in your JQL query to access array elements and calculate string lengths: LBKSfunction main() { return Events({ from_date: "2016-01-01", to_date: "2016-01-07" }) .map(function(event) { // Assuming array_property is an array of strings // This would return the length of the first string in the array return event.properties.array_property[0].length; }); }LBKSThis approach uses the map() transformation in JQL which "Build[s] a new collection by applying the provided function to each element of the input collection" JQL Transformations.Would you like more specific guidance based on where you're trying to access these string lengths (in reports, JQL, etc.)?

ℹ️ Tip: Mention @kapa.ai in the thread for follow-ups or DM the app for 1-to-1 help.

Let me check the knowledge base for you again. One moment! 📚

Based on your question about calculating the average length of strings embedded in an array property in Mixpanel, I'll explain how you can approach this.For this type of calculation, JQL (JavaScript Query Language) in Mixpanel is your best option as it provides the flexibility needed to work with array properties and perform custom calculations.Here's how you can calculate the average length of strings in an array property using JQL: ```function main() { return Events({ from_date: "2016-01-01", to_date: "2016-01-07" }) .map(function(event) { // Assuming array_property is your array of strings var stringArray = event.properties.array_property; var totalLength = 0; var count = 0;

}) .reduce(mixpanel.reducer.avg()); }```This JQL query: 1. Iterates through each event in the specified date range 2. For each event, it accesses the array property 3. Loops through each string in the array, calculating the total length and count 4. Calculates the average length for that event 5. Uses the built-in mixpanel.reducer.avg() function to average these values across all eventsThe mixpanel.reducer.avg() function is specifically designed to "Compute the average of a numeric collection" as mentioned in the JQL Builtins documentation.If you need to filter for specific events or add other conditions, you can modify the query accordingly. This approach gives you the flexibility to handle complex calculations with array properties that might not be directly available through the standard Mixpanel interface.

ℹ️ Tip: Mention @kapa.ai in the thread for follow-ups or DM the app for 1-to-1 help.