topic Re: How to group by every break in pattern? in Alteryx Designer Desktop Discussions

How to group by every break in pattern?

Anonymous1 — Fri, 07 Feb 2020 18:30:42 GMT

I have a report that comes in every month that has a list of employees, whoever is on the list is allowed to use the render farm for that month (fake example). If they are absent on the list, they are not allowed.

I am trying to group it by every break in the pattern.

Real Entry = 1 present for that month, Real Entry = 0 not present.

I have attached the excel data and workbook. Thank you very much.

Re: How to group by every break in pattern?

nivi_s — Fri, 07 Feb 2020 18:31:23 GMT

I've reconfigured the Tile tool so the Tile_Num column should give you the grouping as in the image you'd attached. Let me know if this works!

Re: How to group by every break in pattern?

TonyA — Tue, 04 Feb 2020 19:19:43 GMT

Here's another approach using Transpose.

Re: How to group by every break in pattern?

Anonymous1 — Tue, 04 Feb 2020 20:29:03 GMT

Thank you Nivi and Tony for your help.

This solution does work for me but I'm confused with the logic behind it.

The tile groups data into sets and we have chosen to use unique value grouped by employee name:

So why is it not doing:

Employee A : 1/1/2019 = 1

Employee A : 2/1/2019 = 2

Employee A : 3/1/2019 = 3

etc. etc.

Since these combination of name : date is unique?