Percentile mathematical function

[patel_bm]

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.

[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 · Accepted solution]

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

[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.