Inspire EMEA 2022 On-Demand is live! Watch now, and be sure to save the date for Inspire 2023 in Las Vegas next May.
We'll be completing standard maintenance for our Single Sign-On system on November 30th 6pm Pacific Time for approximately one hour. During this time My Alteryx and sign-in functionality to all My Alteryx programs (Licensing Portal, Community, Beta Program, Case Portal, and others) may be inaccessible. Thank you for your patience.

Alteryx Designer Discussions

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

Need dynamic formula to create average and standard deviation data

MichelleMitchellLutz
8 - Asteroid

Hi! I have a data set with lots (30+) metrics and multiple data names in the Field1 column. I know I could use a Summarize and basic Formula tool to calculate the Average, Standard Deviation, and Coefficient of Variation. However, there are many metrics and new ones could be requested. I tried to use the CReW Dynamic Formula macro but I don't think it's working because my field names are not unique. Any thoughts on a more dynamic approach?

 

Raw Data

MichelleMitchellLutz_0-1651848114343.png

 

Desired Outcome

MichelleMitchellLutz_1-1651848130158.png

 

Not successful CReW Macro output

 

MichelleMitchellLutz_2-1651848335492.png

 

 

 

2 REPLIES 2
KilianL
Alteryx
Alteryx

Hi @MichelleMitchellLutz ,

 

the most useful tool for dynamic workflows is the Transpose, often combined with the Summarize and Cross-Tab.

By transposing all columns except Field1, the option 'dynamic and unknown columns' makes sure to transpose any new Metrics in your dataset. The Summarize is able to get Avg and StdDev for each metric.

 

Find an example attached.

 

 

Please mark this as the solution if it answers your question, it will help others to find solutions quicker.

Kind Regards,
Kilian
Solutions Engineer - Alteryx

MichelleMitchellLutz
8 - Asteroid

Thank you so much! I couldn't wrap my mind around it, but this is perfect. Have a great weekend!

Labels