Help with sequence

Question

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

I have a table below

WeekEndingNameRate2021-01-22152021-01-22142021-01-08152020-12-2514

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 · Accepted Answer

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.