Grouping activities together, according to variable date ranges.

[thoe0059]

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

[Qiu · Accepted solution]

@thoe0059 
When you same day, based on Start or end or both?

You can adjust the Tile Option to reflect that.

[thoe0059]

Hi @Qiu, thanks for quick response - it really helps!

When i say same day, it should be based on both Start and End day, i guess this could be configured by "checking" these in the tile settings? 

I have another questions, that you maybe can answer. If the day is in the format YYYY/MM/DD and the month is September "09" how can i then get rid of the "0" and only have "9"