Is it possible to combine two JQL event queries?

Hi tdwright,

Good question. We can definitely get to the answer you want in a single query by using multiple reducers. First, we'll need an event count for each user/week:

.groupByUser([mixpanel.numeric_bucket('time', mixpanel.weekly_time_buckets)], mixpanel.reducer.count())

This will give us the following output for users:

{

    "key": [

      "00ba56d3-2733-4653-b39c-254f124bcac6",

      1552089600000

    ],

    "value": 8

}

Where key[1] is the week and value is the event count for that user/week.

Then we need to group into weeks and use two reducers, one to count the users (query A), and one to only count the users if they're above a threshold (query .

  .groupBy([user => user.key[1]], [

    mixpanel.reducer.count(),

    mixpanel.reducer.sum(function(user) {

      if (user.value >= eventThreshold)

        return 1;

      else

        return 0;

    })

  ])

The first parameter of the groupBy makes week-piles, then the 2nd param is two reducers. The first is a simple count, but the 2nd is a tricky way to only count certain users. Basically if the user is over the threshold, they count as 1, otherwise they count as 0. mixpanel.reducer.sum() will handle the rest. You can also do it in a single line like this:

mixpanel.reducer.sum(user => user.value >= eventThreshold? 1: 0)

Finally, we need to do some math and transform the date back to a readable format, so we'll use .map()

  .map(item => ({

    'date': new Date(item.key[0]).toISOString().slice(0,10),

    'active users': item.value[0],

    'threshold users': item.value[1],

    'ratio': item.value[1] / item.value[0]

  }))

Hope that helps!

Thanks,

Evan

Hi Tom,

If the events are different, you'll probably need multiple reducers in the groupByUser() as well. One to count event A and one to count event B. You can use the mixpanel.reducer.sum() trick for this:

.groupByUser([mixpanel.numeric_bucket('time', mixpanel.weekly_time_buckets)], [ mixpanel.reducer.sum(event => event.name == eventA? 1: 0), mixpanel.reducer.sum(event => event.name == eventB? 1: 0)

])

In the next groupBy(), you'll need to use value[1] to represent the event count in the mixpanel.reducer.sum() instead of just value.

Thanks,

Evan