Hello, I created this query here in MixPanel, but ...
# questions
f
Hello, I created this query here in MixPanel, but I'm struggling to find out how to turn the result to into a table like the report I attached above. What could I be missing here?
Copy code
function main() {
  return Events({
    from_date: '2019-01-01',
    to_date:   '2022-12-31',
    event_selectors: [
      {event: 'Marketplace:ModelSearch'},
      {event: 'models:download_model'},
      {event: 'models:activate_model'},
      {event: 'plugin:retrofitter_server'},
      {event: 'plugin:updater_server'},
      {event: 'request-model:submit'},
                       ]
  })
  .groupBy(['name','insert_id','user_email','ticker','event_time','event_name'], mixpanel.reducer.count());
}
Also, how do I convert the field "time" to a date format?