Std Dev

[longa0842]

Is there any way to calculate Std Dev for 40K records with 12 columns (months) as the data points for the calculation? I see a lot of suggestions to transpose, but that doesn't seem feasible with that many records.  Essentially recreating how Excel would do it.  Creating ABC XYZ analysis for inventory items.

[rzdodson · Accepted solution]

@longa0842 when able, would you provide a sample dummy set of what you are working with?

[jrgo]

@longa0842 

Definitely wouldn't be feasible to transpose in Excel, but don't see why you can't in Alteryx unless your system is running very low on RAM/Disk space. Remember that - unlike Excel - Alteryx does not have a limit on the amount of rows your data stream contains.

Attached is an example for calculating the StdDev values starting in the table structure you described.

[longa0842]

Ahh - got it, so simple and missed it.  Thanks for the solution.