Variable index performance

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.

Mosaic.xlsx

Workflow

Help

Accepted answers

BrandonB

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

All comments

BrandonB

solution.yxmd

MPearson88

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,

Quick Links

This months top contributors

mceleavey 383

mbarone 337

Hollingsworth 335

LanisC 335

JeffF 335