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:
"score" | Any | > (greater than) | 30
2. Create a custom property:
You'll need to create a custom property to extract the player name corresponding to the score greater than 30. Unfortunately, the provided knowledge sources don't give specific information on how to create such a complex custom property in Mixpanel that would match array indices between two list properties.
3. Break down by the custom property:
After creating the custom property, you would break down your results by this new property to see the player names associated with scores greater than 30.
It's important to note that handling complex array manipulations and index matching between multiple array properties is not a straightforward operation in Mixpanel based on the information provided in the knowledge sources.
For more advanced data manipulations, you might need to consider using JQL (Javascript Query Language) in Mixpanel, which allows for more complex custom queries. However, the documentation notes that JQL is in maintenance mode and not being further developed.
If this level of data manipulation is crucial for your analysis, you might want to consider preprocessing your data before sending it to Mixpanel, or using Mixpanel's Data Pipelines to export your data to a data warehouse where you can perform more complex operations.
For the most accurate and up-to-date information on handling complex data structures in Mixpanel, I recommend reaching out to Mixpanel's support team directly.
