HI @mkeintz Question : With the above condition, does the date range for newgroup 1 expand? Answer: Yes, once any group which will be added to the new group based on gid matches and time overlap then newgroup's time range will be expanded based on the inclusion of the group which is added. 2. By that I mean, what if group Z overlaps with group X (but not group T) and has some other GID in common with X (but not T)? Does group Z then get assigned to newgroup 1? Answer: First, it will assign group X (1) as newgroup 1 and it has ids-103-21 and 103-22 and start_time as 05-04-2022 12:26 &end_time as 05-04-2022 13:02 Next it should check any gids which are present in the newgroup with any other group. So here, condition will satisfy with group Z (4) and time window of group Z (4) also overlaps with newgroup. Now newgroup has ids (103-21,103-22,103-19,103-21) and newgroups time window gets expanded as start_time as start_time as 05-04-2022 11:27 & end_time as 05-04-2022 13:02. Next, It will continue with other group which has matching id then it will check group T (2) which has 103-22 and time overlap condition satisfies so it will be added to newgroup 1. Now Newgroup has ids (103-21,103-22,103-19,103-21,102-58,103-22) and newgroups time window gets expanded as start_time as start_time as 05-04-2022 11:27 &end_time as 05-04-2022 13:06. Next, It will continue with other group which has matching id then it will check group U (3) which has 103-19 and time overlap condition satisfies so it will be added to newgroup 1. Now Newgroup has ids (103-21,103-22,103-19,103-21,102-58,103-22,103-17,103-19) and newgroups time window gets expanded as start_time as start_time as 05-04-2022 11:26 &end_time as 05-04-2022 13:06. 3.And what do you do if group X overlaps with group T but has no common GID? What newgroup value is assigned to group X? Answer: No group will be added with new group until both the conditions (ids in group matches with new group and time overlap with new group) are met. If any of this conditions are not met then the group will be assigned with newgroup. Thank You @mkeintz @Kurt_Bremser
... View more