Alteryx Designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.
Andy Uttley, Alteryx ACE, makes music with Alteryx | Math + Music
SOLVED

Finding abnormal % change from absolute figures

Highlighted
8 - Asteroid

Hello,

 

i have data as below and need to calculate for each product each week what the weekly percentage change is and whether that is normal. I am struggling to calculate a % change for each week. Once i have those i hope to calculate the standard deviation and flag anything that is outside 2 standard deviations as abnormal.

 

Product codesDateVolume
a13/01/20203
a20/01/20204
a27/01/20202
a03/02/20204
a10/02/20203
a17/02/20202
a24/02/20204
a02/03/20205
a09/03/20206
a16/03/20203
b13/01/20202
b20/01/20209
b27/01/20208
b03/02/20207
b10/02/20208
b17/02/20207
b24/02/20208
b02/03/20206
b09/03/20206
b16/03/20208
Highlighted
14 - Magnetar

Hi @Usamah22,

 

it's pretty easy to get the weekly change in %. Here is how to do it:

 

grossal_0-1585343091845.png

 

 

Configuration: 

grossal_1-1585343108784.png

grossal_2-1585343113787.png

Output:

 

grossal_3-1585343145474.png

 

Do you want a "moving" standard deviation or one for a and one for b? Current workflow is attached and I'll help to figure it out when I am clear about the standard deviation.

 

Best 

Alex

 

 

 

 

 

Highlighted
Alteryx Certified Partner
Alteryx Certified Partner

@Usamah22 - attached is an attempt to compute %change.

Capture.PNG

Hope this helps.

 

For standard deviation, the logic will depend on you looking to compute standard deviation at the product level across all weeks, or at a weekly level across all products.

Highlighted
8 - Asteroid

@grossal wrote:

Hi @Usamah22,

 

it's pretty easy to get the weekly change in %. Here is how to do it:

 

grossal_0-1585343091845.png

 

 

Configuration: 

grossal_1-1585343108784.png

grossal_2-1585343113787.png

Output:

 

grossal_3-1585343145474.png

 

Do you want a "moving" standard deviation or one for a and one for b? Current workflow is attached and I'll help to figure it out when I am clear about the standard deviation.

 

Best 

Alex

 

 

 

 

 


SD for each product across weeks please. Thanks for this.

Highlighted
8 - Asteroid

product level across weeks please

Highlighted
14 - Magnetar

There we go!

 

Result:

 

grossal_1-1585345395790.png

 

Workflow:

 

grossal_2-1585345405288.png

 

 

Full workflow attached. Let me know if this is what you are looking for!

 

Note: I added an 'absolut' function around change, that way we also get negative abnormal values.

 

 

 

Alex

 

 

 

 

Labels