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?
+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.
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.