Lower and upper quartiles

[MHS]

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

[binuacs · Accepted solution]

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

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?