Help with sequence

[Ultralightbeam]

Hey guys I am just wondering how to do sequence on alteryx

I have a table below

WeekEnding	Name	Rate
2021-01-22	1	5
2021-01-22	1	4
2021-01-08	1	5
2020-12-25	1	4

and I want alteryx to get the last 3 recent weeks from the table 

So I need to group by the Name and rate and get three weeks only

I have another dates table which contains the WeekEnding - I am thinking of joining my weekstable with table above using weekending as foreign key but that doesn't work

[Emil_Kos]

Hi @Ultralightbeam,

I imagine that you will have at least one row per each week so in the real life it shouldn't be the issue but basically, my workflow shows 3 newest weeks that are in the data set. 

It will not calculate 3 newest weeks from the newest date if that makes sense.

The output:

[Emil_Kos · Accepted solution]

Hi @Ultralightbeam,

Please disregard my previous message.

My workflow now checks the max date and show only 21 days from the max date (3 weeks). 

It is more dynamic and safer.

The output:

Week number part is optional. I have kept it as a check.