Hi, i'm a noob at Alteryx designer, and i want to design a somewhat complex function ( for me atleast).
My goal is to group activities, that happen on the same day. I was able to do so, using filters and filtering the StartDate and EndDate, and finding the activities that happen on that day. But the issue here, is that the Start- and EndDate can change, (imagine new activies are fetched from a data base) The StartDate and EndDates should be handled as variables. But at the moment i'm clueless how to do so.
The matching activities are colored for demo purposes.
I really hope to see if someone can help give a hint in the right direction.
| Record ID | Activity | StartDate | EndDate |
| 1 | Alfa | 2021-02-15 06:00 | 2021-02-15 10:00 |
| 2 | Beta | 2021-06-23 09:00 | 2021-06-23 12:00 |
| 3 | Gamma | 2021-03-21 23:00 | 2021-03-21 24:00 |
| 4 | Delta | 2021-02-15 24:00 | 2021-02-15 16:00 |
| 5 | Gamma | 2021-06-23 08:00 | 2021-06-23 16:00 |
| 6 | Alfa | 2021-02-15 04:00 | 2021-02-15 07:00 |
Kind regards
