Solved

JQL to get First & Last event per user of the day

  • 17 February 2021
  • 1 reply
  • 14 views

I need to fetch all the timestamp of the first and last event per day per user, can anybody help to understand what JQL I can apply?

icon

Best answer by Muffaddal Qutbuddin 17 February 2021, 19:35

Hello @extraaedge , groupByUser can be used to get what you want. It allows to iterate over all the user events in the sequence of their occurrence. So basically first event of the loop is user’s first event and last event of the loop is that users last event.

see my github repo for example code to get you rolling: https://github.com/muffaddal52/Mixpanel---JQL/blob/master/Churned%20Due%20to%20Notification.js

View original

1 reply

Userlevel 2
Badge +2

Hello @extraaedge , groupByUser can be used to get what you want. It allows to iterate over all the user events in the sequence of their occurrence. So basically first event of the loop is user’s first event and last event of the loop is that users last event.

see my github repo for example code to get you rolling: https://github.com/muffaddal52/Mixpanel---JQL/blob/master/Churned%20Due%20to%20Notification.js

Reply


Mixpanel