To get users who have created at least one game (where the event name is "Game created"), you can use Mixpanel's cohort or Insights features:
Option 1: Create a Cohort
1. Go to the Cohort Builder.
2. Set the condition: Users who did the event "Game created" at least 1 time.
3. Save the cohort. This will group all users who have triggered the "Game created" event at least once. You can use this cohort in other reports or export the user list if needed.
Option 2: Use Insights Report
1. In an Insights report, select the "Game created" event.
2. Set the measurement to "Unique Users" to see the count of users who have performed this event.
3. Click on any data point or segment and select "View Users" to see the list of users who created at least one game. You can also save this list as a cohort for further analysis or export it if needed Docs: View Users.
Option 3: JQL (Advanced)
If you need to use JQL, you can write a query to filter users who have performed the "Game created" event. For example:
```
function main() {
return Events({
event_selectors: [{event: "Game created"}]
})
.groupBy(["distinct_id"], mixpanel.reducer.count())
.filter(function(user) { return user.value > = 1; });
}
This will return all users (distinct_id) who have created at least one game [Docs: JQL](https://docs.mixpanel.com/docs/reports/apps/jql).
These methods will help you identify users who have triggered the "Game created" event at least once.
