Calculate percent of whole

user060355
user060355 Member
in Magic ETL

I have rows of client data with 2 fields `weeks` and `recommended_weeks`.  I would simply like to know what percent of rows have `weeks` = `recommended_weeks`.  For some reason I can't seem to make this work.  I tried the following but it's showing me ALL rows, rather than an average.

 

sum(case when `weeks` = `recommended_weeks` then 1 else 0 end) / count(`id_client`)

 

It seems like it should be simple enough to separate the data into 2 populations (one where `weeks` = `recommended weeks` and one where `weeks` != `recommended_weeks` but for whatever reason, I cannot seem to get a single number out of the data.

Comments

  • jaeW_at_Onyx
    jaeW_at_Onyx Coach

    @user060355 , it sounds simple, but i'm not sure i follow your data structure.

    can you upload a sample?

    what happens when you break your beast mode into separate parts (i.e. which part is breaking? the numerator or the denominator?)

    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