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.
SOLVED

Variable index performance

Highlighted
5 - Atom

Could someone please help with something that I cannot get to work. I am looking to pull out the highest indexing variable per customer type, I do not need the value but I need the related variable . e.g A01 highest indexing measure is 12.32 for age and that is in the 41-45 variable i want to see that. There are 66 customer types and 12 measures so I need to see the top indexing variable by customer type for each of the 12 measures.

 

Thanks in advance.

Highlighted
Alteryx
Alteryx

Probably something like this. I added the "Who we are" filter at the end so I could check my work but you can remove that if it isn't needed. Basic concept is a transpose to get all of the columns into one, a sort so the values are descending, and then a sample of the first record of each group. Workflow is attached. 

 

solution.png

Highlighted
5 - Atom

Brandon, 

 

Thank you that looks exactly what i want but i cant download your solution as i have an older version of Alteryx Designer, is there any way you could share on an older version or do you have any other way of sharing?

 

Thanks,

 

 

Highlighted
Alteryx
Alteryx

What version do you have? I can tweak something for you

Highlighted
5 - Atom

I have managed to replicate this so it has now worked, thank you

 

Labels