Lower and upper quartiles

Hello Alteryx Community!

I wanted to reach out to see if anyone has a tool or calculation that can be used to determine the 1st and 3rd quartiles from a data set. I am trying to build out the 5 number summary on a few data sets and can get the min, max, and median through the summarize tool and would like to know what everyone else is using to determine the quartiles.

Thanks for the help!

Matt

Data Investigation

Accepted answers

binu_acs

@MHS the below post might help

https://community.alteryx.com/t5/Alteryx-Designer-Discussions/Calculating-Quartiles/td-p/28479

danilang

Hi @MHS

If you're already a Summarize tool to calculate the min, max, etc, etc, include the 25th and 75th percentile to get your 1st and 3rd quartiles as well

Dan

All comments

binu_acs

@MHS the below post might help

https://community.alteryx.com/t5/Alteryx-Designer-Discussions/Calculating-Quartiles/td-p/28479

apathetichell

I'm not a huge fan of multi-field bining but...

MHS

Thank you!

I knew it would be something fairly straightforward that I was overlooking.

danilang

Hi @MHS

If you're already a Summarize tool to calculate the min, max, etc, etc, include the 25th and 75th percentile to get your 1st and 3rd quartiles as well

Dan

ptaylor_ds

This does not always generate the right value for me... Any word on when/if the bug will be fixed?

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703