Our iOS app allows airline employees to manage guest reservations. We’re looking to measure the employee/guest interaction time, and I thought a reliable way to do this would be to measure the average time between the first custom event and the last custom event with a given attribute - the confirmation code.
Here’s what I started with:
SELECT (max(timestamp)-min(timestamp))/60000 as 'Time in Minutes' FROM <CustomEvents> WHERE appName = <appName> AND confirmationCode IS NOT NULL FACET confirmationCode
While this gives me a list of interaction times, chart types and functions can’t be nested, so I can’t throw an
average() in there or seemingly look at this data in any meaningful way.
Then I thought of adding something like
timeInReservation as a custom attribute to my events, but the problem with that is we have no way of knowing which event a user will trigger last. I tried this:
SELECT latest(timeInReservation) FROM <CustomEvents> WHERE appName = <appName> FACET confirmationCode
But again, this just gives me a list and can’t be nested with
Is there some NRQL magic I could use here?