Question

How do I use upper and lower limit to fetch data from mixpanel

  • 23 July 2019
  • 1 reply
  • 16 views

Badge

Hi Experts,

I want to fetch the data from the mixpanel based on some query. I have attached the snapshot for your reference.



1 reply

Userlevel 3
Badge

Hey @praveer, not sure if I am understanding your question fully but it sounds like you want to filter the duration property between 0-5000000 from the event Application: Telemetry?


Maybe this query can help you get started?


function main() {

  return Events({

    from_date: '2019-06-29',

    to_date: '2019-07-29',

    event_selectors: [{event: 'Application: Telemetry'}]

  })

  .filter(function (tuple) {

   return tuple.properties.duration>=0 &&
    tuple.properties.duration<=6000000;

  })

  .reduce(mixpanel.reducer.count());

}


Hope this helps get you started on your query. There is also further documentation here on example queries with JQL. 🙂


Reply