Six Sigma score calculation in ETL

Reply
Highlighted
White Belt

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.

Tags (1)
Highlighted
Black Belt

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
______________________________________________________________________________________________
Highlighted
Black Belt

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 heart in the post that helped you.
**Please mark the post that solves your problem by clicking on "Accept as Solution"
Announcements
Domopalooza 2021 Call for Presenters: We want to hear how Domo is revolutionizing the way you do business!

Click here to submit your story.