Filtering Player Statistics Events in Mixpanel for Scores Over 30

Hi Tarun 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> 👋

To achieve this in Mixpanel, you can use a combination of filtering and custom properties. Here's how you can approach this: 1. First, you'll need to use list filtering to select events where any element in the "score" list property is greater than 30.2. Then, you can create a custom property to extract the player name corresponding to the score greater than 30.Here's a step-by-step approach: 1. Filter the events: Use the "Any" operator to filter events where any element in the "score" list is greater than 30. List Filter Your filter would look like this:

ℹ️ 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 create a custom property for this specific use case in Mixpanel, you can use the custom property feature. However, it's important to note that creating a custom property that matches array indices between two list properties is a complex operation that may not be directly supported by Mixpanel's standard custom property functionality.Based on the information provided in the Custom Properties documentation, here's a general approach you could try: 1. Click the plus button to the right of the search bar in your Mixpanel report. 2. Select "Event Property" to open the property builder. 3. Give your property a name, such as "High Score Player". 4. Click into the formula bar to start defining your custom property.The challenge here is that the formula needed for your specific use case is quite complex and may not be directly achievable using the standard functions available in Mixpanel's custom property feature. The custom property would need to: 1. Find the index of scores greater than 30 in the "score" array. 2. Use that index to retrieve the corresponding player name from the "player" array.Unfortunately, the provided knowledge sources don't give examples of custom properties that can perform such complex array operations or index matching between multiple array properties.Given the complexity of this operation, you might need to consider alternative approaches: 1. Preprocess your data before sending it to Mixpanel, creating a new property that already contains the desired information. 2. Use JQL (Javascript Query Language) for more complex custom queries, although it's worth noting that JQL is in maintenance mode. 3. Export your data using Mixpanel's data pipelines and perform this analysis in a more flexible environment like a data warehouse.For the most accurate and up-to-date information on handling such complex custom properties in Mixpanel, I recommend reaching out to Mixpanel's support team directly. They would be best equipped to advise on whether this specific use case can be handled within Mixpanel's current custom property capabilities.

ℹ️ 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! 📚

Certainly! I can provide you with a JQL (JavaScript Query Language) script that addresses your specific scenario. Here's an example of how you might structure the JQL query: LBKSfunction main() { return Events({ from_date: '2023-01-01', to_date: '2023-12-31' }) .filter(function(event) { return event.properties.score.some(score => score > 30); }) .map(function(event) { var highScoreIndex = event.properties.score.findIndex(score => score > 30); return { score: event.properties.score[highScoreIndex], player: event.properties.player[highScoreIndex] }; }); }LBKSThis JQL script does the following: 1. It selects events from a specified date range (you should adjust these dates as needed). 2. It filters the events to only include those where at least one score is greater than 30. 3. It then maps each event to an object containing the first score greater than 30 and its corresponding player.To use this JQL script in Mixpanel: 1. Navigate to the JQL interface in Mixpanel. 2. Copy and paste this script into the JQL editor. 3. Run the query to see the results.Please note that while this JQL script should work for your scenario, there are some important considerations: 1. As mentioned in the JQL documentation, JQL is in maintenance mode and Mixpanel is not investing in it further.2. The JQL documentation also states: "If you would like to run arbitrary queries on your Mixpanel events, please use our Data Pipelines add-on to export your events to your data warehouse."3. There are limitations to JQL queries, including a timeout after 2 minutes of run-time and a maximum of 5 concurrent queries and 60 queries per hour, as noted in the Custom JQL Query documentation.Given these limitations, for complex or frequent analyses of this type, you might want to consider using Mixpanel's Data Pipelines to export your data to a separate data warehouse where you can perform more flexible and powerful analyses.

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