4. Check Total Sequence Duration
Duration Length checks how long a sequence (a series of actions) took, from its first matched record to its final matched record. Use it to find sequences completed within a time limit or taking at least a specified amount of time.
Build the Query
- Drag the required events onto the canvas and connect them in order.
- Add Duration Length from System Defined Events.
- Place it immediately before End, following either the final named event or Any.
- Choose the comparison and enter the duration in milliseconds.
Start → Request Received → Processing Started → Response Sent → Duration Length ≤ 2,500 ms → EndUsing Any: You can place Any directly before Duration Length to capture activity after a named event.
Start → Login Failed → Any → Duration Length ≥ 300,000 ms → EndAny captures subsequent records until the EventOwner’s queried records end or the sequence record limit is reached. Duration Length then checks the time from the sequence’s first matched record to its last captured record.
The condition is checked when capture closes. It does not stop capture when the condition first becomes true.
If Any captures no additional records, the sequence duration is 0 ms.
How It Works
After the required events match for the same EventOwner, zinzu checks the elapsed time between the first and final matched records.
With Duration Length ≤ 2,500 ms (2.5 seconds):
- 2 seconds: The sequence completes.
- Exactly 2.5 seconds: The sequence also completes.
- 3 seconds: The sequence is marked incomplete, even though the actions occurred in the correct order.
When Duration Length follows a named event, the check happens immediately when that event matches. When it follows Any, the check happens when capture closes. Duration Length does not consume an additional record.
When to Use It
Find Request Received → Processing Started → Response Sent sequences completed within 2.5 seconds. Set Duration Length to ≤ 2,500 ms.Find Product Viewed → Any → Payment Completed sequences taking at least 30 minutes. Set Duration Length to ≥ 1,800,000 ms. Inspect the captured activity between the two named events to understand what happened along the way.Find Ticket Opened → Any → Ticket Resolved sequences completed within 24 hours. Set Duration Length to ≤ 86,400,000 ms.Note: Duration uses timestamps in your data, not the time zinzu takes to run the query. 1 second = 1,000 milliseconds.
Next: Submit the query and view results.