Standardize / Normalize Metrics
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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!
Solved! Go to Solution.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Ah, I'm not sure how I missed this. Thank you @RodL!
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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. . . .
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
@ToddM - this is a great idea and would be extremely useful.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Great idea!
One of you needs post the idea on the Ideas section of the Community, and then the rest of you need to vote for it.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
You'll get a star from me - that's a great feature!
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
I've posted the idea here: http://community.alteryx.com/t5/Alteryx-Product-Ideas/Add-Standardization-Z-Scores-to-Summarize-tool.... Wasn't sure how to tag you in the post but thank you ToddM for your awesome suggestion!
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hi Kevin,
Would love to try you macro but couldn't get it to work.
Do you have any basic instructions?
