Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.

Ranking Decile

kunalswami
7 - Meteor

Decile (from 1 to 10) of the order number based on «Ranking» value.

If multiple order number with same ranking need to split between different deciles, then order line with earliest «DATE» gets higher decile.

 

Please help.......

3 REPLIES 3
gautiergodard
13 - Pulsar

Hey @kunalswami 

Can you do something like this?

kunalswami
7 - Meteor

Want to create a new col Decile based on ranking

TimN
13 - Pulsar

Try the tile tool.  There are options - "Equal Sum", etc.  I attach an example.

Labels