How to create a rank using two columns?

UserBird
Dataiker
How to create a rank using two columns?
Hello,

I have created a score for each row in my data set. Then I used 'bin' to create a column with the categories A,B,C,D based on the score (A with the top scores and D with the bottom scores). How can I create in DataIku a single column that goes from 0-100 for each category? My goal is to see where each row stands relevant within its category.

Thanks!
0 Kudos
2 Replies
Alex_Combessie
Dataiker Alumni

Hi,



You can use a visual "Window" recipe to do that ๐Ÿ™‚



First, define your windowing settings (partitioning column will be category and order column will be score)





Then, compute the rank using the quantile method with 100 quantiles.



 



Cheers,



Alex

0 Kudos
UserBird
Dataiker
Author
Thanks Alex. This answers my question ๐Ÿ™‚
0 Kudos