Hello everyone,
I’m new to the KNIME tool. For several days I’ve been looking for a way to prepare and calculate indicators.
Here is a simplified table of my input data:
Date | VisitorID | IDEvent | Stage | Sub-stage
01/01/2021 10:30 am | 123 | 1 | 1 | yes
01/01/2021 10:31 am | 345 | 2 | 1 | yes
01/01/2021 10:31 am | 345 | 3 | 2 | yes
Here is the table I would like to output:
Date | Stage | Sub-stage | Number of visits | Passage rate
01/01/2021 | 1 | yes | 2 | 0%
01/01/2021 | 1 | no | 0 | 0
01/01/2021 | 2 | yes | 1 | 50% ***
01/01/2021 | 2 | no | 0 | 0%
*** Where the count verifies that the previous step has been completed by the visitor.
Thanks in advance for your help and this great tool!
Nina