GroupBy non-date column to get number of days on a date column

How do I ?
GroupBy a non-date column to get number of days between min date and max date on a date column?

There are other columns as well that are numerical or categorical that require a mode/mean.

Hi @tims , just group by the column(s) you want to group by, and then for the aggregation, just get the minimum and maximum of your date columns:

This will produce the Min*(Date) column containing the minimum date for the group and the Max*(Date) containing the maximum date for the group.

You can then use the Date&Time Difference node to find the difference in days between these 2 columns:

1 Like

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