Smart Tile for multiple fields in Alteryx

Question

My data set contains around 100 numeric fields. For each of these field, I want to apply Smart Tile to categorize them as Extremely High, High, Above Average, Average, Below Average, Low and Extremely Low. How can I apply Smart Tile to all 100 fields simultaneously?

hainguyen281998 · Answer

Thank you. I tried that and it work. At step 4, I used Cross Tab instead of Transpose to convert the dataset back to its original format.

Raj · Answer

@hainguyen281998 
another method

* Input Data: Start with an input tool to bring in your dataset containing the 100 numeric fields.

* Transpose Tool: Use a Transpose tool to convert your dataset from wide to long format, so that each numeric field becomes a single row.

* Formula Tool: Add a Formula tool to create a new field that calculates the Smart Tile value for each numeric field. You can use conditional statements within the Formula tool to assign the appropriate category (Extremely High, High, Above Average, Average, Below Average, Low, Extremely Low) based on the Smart Tile value.

* Transpose Tool (optional): If needed, use another Transpose tool to convert the dataset back to its original wide format.

* Output Data: Finally, use an Output tool to export the dataset with the Smart Tile categories applied for each numeric field.

formual to use
eg-
IF [NumericField] >= SmartTile(0.9) THEN "Extremely High"
ELSEIF [NumericField] >= SmartTile(0.7) THEN "High"
ELSEIF [NumericField] >= SmartTile(0.5) THEN "Above Average"
ELSEIF [NumericField] >= SmartTile(0.3) THEN "Average"
ELSEIF [NumericField] >= SmartTile(0.1) THEN "Below Average"
ELSEIF [NumericField] >= SmartTile(0.05) THEN "Low"
ELSE "Extremely Low"
ENDIF

hope this helps.

apathetichell · Answer

add a recordid.

transpose your numeric columns.

add your tile tool.

output your verbose names of your [Value] field.

group by [Name]