Percentile mathematical function

I was wondering if we have a very simple mathematical function to calculate a specific percentile data point in a data array/column. Python equivalent will be Numpy.percentile() OR quantile() functions. R equivalent will be quantile function. I am at loss to see why should these not be part of Formula tool Math functions unless I have completely missed them.

PS: I understand we can use R or Python tools for the same. But I am not sure if this isn't already available in Alteryx tools.

Transformation

Data Investigation

Accepted answers

AbhilashR

Hi @patel_bm, the Summarize tool allows you to compute the percentile values for a range of data

Or addition to @RolandSchubert's suggestion, you could also use the Moving Summarize tool available within the Crew Macro toolset to compute percentile values. More on it is available at this link: http://www.chaosreignswithin.com/2014/12/moving-summarize.html

The zip file in this link will help install Crew Macros for you: http://www.chaosreignswithin.com/p/macros.html

All comments

RolandSchubert

Hi @patel_bm ,

have a look at this post, maybe it's helpful: Percentile Macro . A macro is avaliable for download.

Hope this is helpful

Best,

Roland

AbhilashR

Hi @patel_bm, the Summarize tool allows you to compute the percentile values for a range of data

The zip file in this link will help install Crew Macros for you: http://www.chaosreignswithin.com/p/macros.html

patel_bm

@AbhilashR That's perfect. I knew I was missing something. We couldn't have missed such important function.

Thanks a lot.

jcanavanBDO

but that seems to only calculate the 50th percentile, what about others like the 25th or 75th P?

kathleenmonks

@jcanavanBDO in the bottom left of the Summarize tool configuration you can choose what percentile you want. The default is 50 but this can be changed.

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703