This Analytics Edge wizard is used to convert the selected column into a number representing either the rank order or it’s percentile, decile or quartile position.
It is typically used to segment data or to establish a normalized value for further analysis, such as using Filter and Match to obtain details for the top 10%.
Select Columns – select the columns to be converted by position (column letter) or By Name.
Change Selected Columns Into
Rank – convert the value in the selected columns to a rank number starting at 1 and counting up. Duplicate rows will have the same value, and the next number will be skipped.
Percentile – split the values in the column into 100 ordered groups and change the value to a number between 1 and 100.
Decile – split the values in the column into 10 ordered groups and change the value to a number between 1 and 10.
Quartile – split the values in the column into 4 ordered groups and change the value to a number between 1 and 4.
Larger value will rank higher/lower – select whether larger values will rank higher (e.g. counting up), or whether larger values will rank lower (e.g. top 10).