'ClickHouse SequenceCount group funnel
I've been trying to use sequenceCount in order to process a funnel analysis on a website data. We want to track how many user can reach from point A to point B. sequenceCount is a perfect fit for this need as we have trackers that follows the user's interaction on the website. However, let's say that there is not only one tracker but many that trigger the point A in our funnel analysis. This would mean that currently we would have to use sequenceCount for EACH triggers A and make them point to B. This problem might lead to situation where we have to write plenty of sequenceCount and could kill all performance. I've been looking on the web for answers but I didn't find any about that.
I'm looking for thoughts that could solve the problem or avoid it
Sources
This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.
Source: Stack Overflow
| Solution | Source |
|---|