How count the event between start event and end event?

Comments

1 comment

  • Avatar
    Rick Jury

    Hi flik you could try something like this:

    | json field=_raw "sessionId","formType","formId"
    | min(_messagetime) as start, max(_messagetime) as end, count as events by sessionid,formtype,formid
    | (end - start) / (1000 * 60 ) as duration_s

    0
    Comment actions Permalink

Please sign in to leave a comment.