v.19.14Improvement

Added Strict Parameter in Windowfunnel()

Official CH changelog text
Added strict parameter in windowFunnel(). When the strict is set, the windowFunnel() applies conditions only for the unique values. #6548 (achimbab)
Added a strict parameter to the windowFunnel() function, enabling it to apply conditions exclusively to unique values.

Why it matters

The strict parameter allows users to refine the behavior of windowFunnel() by focusing only on unique events when evaluating funnel steps. This addresses scenarios where duplicate events could skew funnel analysis, providing more accurate insights.

How to use it

To enable this feature, pass the strict parameter as true in the windowFunnel() function call. For example:

SELECT windowFunnel(time_column, event_column, window_size, strict=true) FROM table

Related resources

PreviousNext