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
Solved! Go to Solution.
@MHS the below post might help
https://community.alteryx.com/t5/Alteryx-Designer-Discussions/Calculating-Quartiles/td-p/28479
I'm not a huge fan of multi-field bining but...
Thank you!
I knew it would be something fairly straightforward that I was overlooking.
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
This does not always generate the right value for me... Any word on when/if the bug will be fixed?