I have an issue with Mixpanel merge that causes random users to be merged together. I am trying to debug this issue and for that I need a JQL query that shows me which users have more than 1 (or X) distinct IDs. They can be anonymous IDs (unidentfied users) or my app’s IDs.

Mixpanel shows these distinct ids in the user dashboard:

Is there any way to write a JQL query that will return the users that have more than X distinct IDs ?

I was trying this:

function main() {
  return Events({
    from_date: "2024-08-01",
    to_date: "2024-08-08"
  })
  .groupBy(["distinct_id"], mixpanel.reducer.count())
  .filter(result => result.value > 1)
}

But I am not sure this is correct.