Obtain deciles in one function or tool

I know that I can use the "Summarize" tool to get a percentile. However, what if I want the deciles? I don't want to apply the Percentile function within the Summarize tool 10 times and enter the percentage rank each time. I want one function or one tool that will provide the deciles (or any arbitrary set of evenly divided percentiles).

Is this possible in Alteryx?

By deciles, I mean the 10th percentile, 20th percentile, ... , 90th percentile, and 100th percentile.

Preparation

Data Investigation

Accepted answers

MarqueeCrew

@ecai,

Please try using the TILE tool. You can create deciles there.

Cheers,

Mark

All comments

MarqueeCrew

@ecai,

Please try using the TILE tool. You can create deciles there.

Cheers,

Mark

kth89456

I have tried using the TILE tool, but I cannot keep the deciles to be used for further calculations.

In short, I need to evaluate the deciles of multiple columns and then want to assign a value based on the decile of each column. The TILE tool appears to create a non-permanent naming that I can't use to assign a value. Can you help?

Quick Links

This months top contributors

AkimasaKajitani 389

mceleavey 388

mbarone 337

Hollingsworth 335

LanisC 335