Six Sigma score calculation in ETL

user035054
user035054 ⚪️
in Magic 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.

Comments

  • ST_-Superman-_
    ST_-Superman-_ 🔴

    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
    ______________________________________________________________________________________________
  • jaeW_at_Onyx
    jaeW_at_Onyx 🔴

    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"

Categories