Standardize / Normalize Metrics

Does anyone know of a tool or formula in Alteryx that can standardize / normalize data? I see there's a standarize_unit-interval supporting macro but can not find this in Designer. Here's the use case: I have 100,000 records of calls that were answered from productX and 15,000 records of calls abandoned from productY. I need to standardize / normalize the data so it's comparable. Thanks for the help!

Datasets

Tips and Tricks

Macros

Common Use Cases

Predictive Analysis

Data Investigation

R Tool

Prescriptive Analytics

Accepted answers

RodL

They standardization processes used in tools such as the K-Centroids Cluster Analysis are found in the

"C:\Program Files\Alteryx\bin\RuntimeData\Macros\Predictive Tools\Supporting_Macros" directory (if default installation settings are used).

You can find both an Unit Interval and a Z-Score method there.

All comments

RodL

They standardization processes used in tools such as the K-Centroids Cluster Analysis are found in the

"C:\Program Files\Alteryx\bin\RuntimeData\Macros\Predictive Tools\Supporting_Macros" directory (if default installation settings are used).

You can find both an Unit Interval and a Z-Score method there.

Gtrujillo

Ah, I'm not sure how I missed this. Thank you @RodL!

ToddM

I would love to see standardization (Z scores) appear in the Summarize tool's add -> numeric menu. Standardized inputs are a very common requirement of analytics algorithms. . . .

KevinMcCoy

I created a macro that will normalize/denormalize datasets. Additionally, it will also normalize new datasets based off of the parameters from your initial model building normalizing metrics (so that you can use an old model on new data).

It's located at Feature Normalization.

EvanSchmidt

Hi Kevin,

Would love to try you macro but couldn't get it to work.

Do you have any basic instructions?

TimothyL

Hi Kevin,

Same here. The output display no value while the parameter output tab can display.

Quick Links

Unanswered
Community Events
Groups

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703