Counting taking into account the date of the event and previous events for an ID

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

I am no sure whether I understand your task, but you could take a look at Groupby node or Lag node (to access prior rows) and see whether the provide a starting point for you
br

This topic was automatically closed 90 days after the last reply. New replies are no longer allowed.