This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
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.
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.
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?