v.20.4New Feature

Add strict_order option to windowFunnel function

Add 'strict_order' option to windowFunnel() #9773 (achimbab)
Added a strict_order option to the windowFunnel() function in ClickHouse.

Why it matters

This feature enhances the windowFunnel() function by allowing users to enforce a strict temporal order condition in event sequences. It solves the problem of accurately detecting funnels where events must occur in a precise chronological order, improving the reliability and correctness of funnel analyses.

How to use it

Users can enable the strict order check by passing the strict_order parameter to the windowFunnel() function in their SQL queries, for example:

SELECT windowFunnel(60, event, user_id, sequence, strict_order = 1) FROM ...