Start Free Trial

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED

Calculating Week Over Week Difference by State

KmbrlyPC
8 - Asteroid

I am needing to calculate the week over week change for a location. There are numerous locations and several weeks. Here is an example of some data and the desired result. Thank you for your help.

WoW Change.PNG

2 REPLIES 2
raychase
11 - Bolide

Sort your data by state and date, then use a multi-row formula to perform [current row value] - [row - 1 value].

 

Workflow attached.

KmbrlyPC
8 - Asteroid

It works perfect, thank you!

Labels
Top Solution Authors