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.