Six Sigma score calculation in ETL
Hi,
I'm trying to calculate the six sigma score in ETL, the excel formula is =NORMSINV(1(((Errors/Total records)*1000000)/1000000))+1.5
I found a Redshift function CUME_DIST but it doesn't do what I need. Any inputs to achieve this is much appreciated.
0
Comments

NORM.S.INV() ... I believe is just the inverse of the CUME_DIST() function that you found in redshift.
I'm not sure why your formula is adding 1.5 to the end either.
______________________________________________________________________________________________
“There is a superhero in all of us, we just need the courage to put on the cape.” Superman
______________________________________________________________________________________________0 
so what is the gap between what you're getting and what you want?
"it's not doing what i need it to do..."
Jae Wilson
Check out my 🎥 Domo Training YouTube Channel 👨💻
**Say "Thanks" by clicking the ❤️ in the post that helped you.
**Please mark the post that solves your problem by clicking on "Accept as Solution"0
Categories
 10.7K All Categories
 13 Getting Started in the Community
 37 Beastmode & Analytics
 2.1K Data Platform & Data Science
 59 Domo Everywhere
 2.7K Charting
 2.5K Ideas Exchange
 1.3K Connectors
 362 Workbench
 303 Use Cases & Best Practices
 500 APIs
 118 Apps
 48 News
 753 Onboarding
 1.2K 日本支部
 Private Company Board