Count per customerID, per date

Dear KNIME users,

I need help - I’m trying to add a column which counts/ ranks the data per customerID on the minimum date per customer and then ranks upwards depending on the amount of rows per customerid.
See below as example, the yellow column which I called rank is the expected outcome which I want to get through KNIME:
image

Hi @doppio

Welcome to KNIME Forum! This works best when your Date column is converted to a date format. See count_per_customerID_per_date.knwf (18.0 KB)


gr. Hans

5 Likes

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