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 |
Solved! Go to Solution.
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!