Alteryx designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.
SOLVED

RANKING

Asteroid

Hi all,

I am trying to create a rank for every unique identifier score, using the multi formula tool but even though i think my configuration may be correct i am not getting the desired output as i described. 

for instance between records 1-20;   2.7 should be ranked 1, followed by the next in order of magnitude 2 etc .

Can someone help me with this please 

attached is the workbook

and a screen shot multi formula tool.

razzy_0-1573682509201.png

Highlighted
Fireball

Hi @razzy 

 

You could use a Tile tool, I've attached sample as I could not access your attachment.

 

 

Highlighted
Alteryx Certified Partner

Hi @razzy ,

 

If I understood right your problem, you only missed a sort tool in your workflow as attached workflow.

 

Let me know if that works for you.

 

Best,

Fernando V.

Highlighted
Asteroid

Thank you both

Labels