Ashley W.

You're most welcome! :)

Hey Alex, sorry but filtering a breakdown by its count of values would be a product gap. 😕 You can submit a product gap from the top right hand corner of the UI by clicking on the question mark icon > Submit Feedback:

If I’m understanding you correctly, I think what you want is to use JQL to break down the number of “Session Start” (manually tracked) events by the number of unique users right? Same as this report: https://mixpanel.com/s/KAqol If so, you can use the following JQL query - you’ll find that the JQL output and the report results will line up.

function main() {
  return Events({
    from_date: '2025-01-16',
    to_date:   '2025-01-23',
    event_selectors: [{event: "Session Start"}]
  })
  .groupBy(["properties.$user_id"], mixpanel.reducer.count())
  .map(function(row){
    return {
      $user_id: row.key[0],
      num_of_session_start: row.value
    }
  })
} 

If you were to compare the total number of unique users for metric A + metric B vs metric C, the figures should be the same. For example, in this sample report (screenshot below). Since you’re seeing a discrepancy in your report, would you mind sending me a link to it so I can take a closer look?