Week on Week Movements

RaghavanR

Hi,

I have a situation that I have data by weekend (weekend is on Friday) and it is a cumulative one for the month and want to arrive at Week on week  movements.

Can some one please guide me on how to get this done in Alteryx?

Sample data is as below:

Date	Identifier	Amount	WoW Movement
4/12/2020	A/cts Closed	100	100
11/12/2020	A/cts Closed	180	80
18/12/2020	A/cts Closed	200	20
24/12/2020	A/cts Closed	250	50
31/12/2020	A/cts Closed	300	50
08/01/2021	A/cts Closed	10	10
15/01/2021	A/cts Closed	110	100
22/01/2021	A/cts Closed	180	70
29/01/2021	A/cts Closed	200	20

clmc9601

Hi @RaghavanR,

Do you mean you want to calculate the numbers in the WoW column that you provided? If so, does this accomplish your goal?

 I hope it helps!

week over week movement raghavan.yxmd