Alteryx designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.
Alteryx is here to help you solve your biggest data challenges. Read about the new Virtual Solution Center here.

Rank Value based on Values in a Different Field

5 - Atom

I've done a lot of searching on countif solutions and can't seem to find one that works for my situation. 

 

I have data set that ranks about 150 people on ytd performance on a particular metric. I have a field that adds a scenario for the following week and calculates their ytd value based on if this scenario happens. 

 

I need to be able to rank the new ytd value based on the actual ytd value from the current week. It's a way to see how their ranking would change next week holding everyone else constant. 

 

In excel it's a simple countif formula, but I really need to be able to do this in Alteryx if I can. 

 

Below is a screen shot of what I'm trying to do. 

 

countif.png

 

 

Highlighted
ACE Emeritus
ACE Emeritus

I would....

  1. Apply a RecordID to retain the current ordering
  2. Sort by "new_value"
  3. Do a MultiRow Formula to create the new rank
  4. Sort on RecordID to get back to your original ordering

I assume the "new_rank" you want  would be 2,1,3,4,4,5, etc...? Or is anything less than -1 consider rank 1?

Labels