Hello,
I am somewhat new to Alteryx and am trying to do something seemingly simple. I have a group column and a date column (and a column for values, so each date will be listed more than once per group). I want to (in the end) keep only the 10 largest values for each group. I have sorted the columns so that they are grouped by group and date and then listed (largest to smallest) by value. I know what to return a reference count (1,2,3...,n) per group per day. Basically, a Record ID with criteria is what I'm after. Any help would be great! I have attached a sample workflow.
Thanks!
Solved! Go to Solution.
Ben, this is very helpful and both methods worked well. Thanks!