v.24.10Improvement
Added strict_once mode to windowFunnel function to prevent duplicate event counts
Addedstrict_oncemode to aggregate functionwindowFunnelto avoid counting one event several times in case it matches multiple conditions, close #21835. #69738 (Vladimir Cherkasov).
Why it matters
Thestrict_once mode addresses the issue where the windowFunnel function could count the same event multiple times if it satisfies more than one condition. This improvement enhances accuracy in event sequence analysis by preventing duplicate counts of the same event.How to use it
To enable this feature, use thewindowFunnel aggregate function with the strict_once mode specified. For example:SELECT windowFunnel('strict_once', time_column, condition1, condition2, ...) FROM tableThis will count each event only once even if it matches multiple conditions.