Standard deviation on a row of data ?

[mgirdwood]

Hi

I am new to Alteryx, i have looked at other examples and googled but can not seem to work this out.

I have a table of data (below) with rows of data that I want to to find the Standard Deviation for, for each row.

I am sure this should be a one node fix but I can not seem to find the way.

If anyone has a suggestion I would be grateful

Mark

[DataNath · Accepted solution]

Hey @mgirdwood, if you Transpose your data to start, selecting all fields other than your numeric ones you want to find the StDev of as your Key Columns:

You can then use a Summarize tool to go Add > Numeric > Standard Deviation:

Finally, you just need to Join it back on based upon the row 'identifier' i.e. [Type] here:

[mgirdwood]

Thanks Nath,

I had sort of got near there but couldn't get the SD returned to the table, the numbers are slightly out but apparently there are a couple of methods of calculating SD so I will need to check which one is built in to Alteryx.

Mark