Comments
-
Works now, had some null values I was not aware of that were affecting the calculations for some reason. IFNULL solved it.
-
Hi, I used rank and window with a group by after to get the ranking of that data set. I divided the rank by highest rank to get the % of the rows. So example is mark 0 then % = 1 , Mark 7 then % 0.4 Mark 8 then % 0.2 etc... the higher the number the smaller the percentage. I was trying to get rid of the highest marks as…
-
Oh Nevermind got it! Thank you guys!
-
Thanks, i can't set my data flow to run once a week it runs whenever the data set is updated. Thus I need this to work dynamically. I've managed to rank by week, each week has a ranking, however still struggling to get them to have a percentage instead of ranking.
