Does JQL enable filtering 'first time' events?

  • 17 December 2020
  • 1 reply

I’d like to be able to use JQL to extract only the first time each user does a given event. I don’t want to get every instance of this event and then filter as I’m using the RMixpanel R package to pass the JQL to the mixpanel endpoint and don’t want to run into API rate limit issues.

Is it possible to do this in JQL?

1 reply

Userlevel 6
Badge +3


Out of the box, the “first time” feature was not built to be supported in JQL the same way that we’ve built it for our core reports. 

Of course, you can always write up a script to define the first time an event is triggered, but typically we see JQL as a tool to debug rather than a tool to query on demand.