Advent of Code is back! Unwrap daily challenges to sharpen your Alteryx skills and earn badges along the way! Learn more now.

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.

Whisker box quartile calculation not correct

NickDelaby
5 - Atom

When drafting a whisker box plot through the 'Interactive chart', the quartile / percentile calculation is not correct when comparing it to quartile / percentile calculations done through either the 'Summarize tool' or when simply looking 'Browse' - 'Profile' option.

 

I've looked at multiple other questions in this scenario, but no concrete solution was proposed (see below).

Does anybody else have experience with this issue and found a viable solution in order to populate the correct values in the whisker box plot?

 

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

 

https://community.alteryx.com/t5/General-Discussions/Median-and-3rd-Percentile-Calculation-Error/m-p... 

6 REPLIES 6
ptaylor_ds
6 - Meteoroid

Have to agree with Nick on this... it is not solved.  The results I get from using the percentile calculation are inconsistent and often wrong, e.g. the 2nd quartile is higher than the median.  This looks to be a bug that needs fixed. 

NickDelaby
5 - Atom

Is there any known way to escalate this?

ptaylor_ds
6 - Meteoroid

Product Management at Alteryx... This is a bug.  Please look into this and see if we can get it fixed ASAP.  This is  affecting at least two customers and who knows who else is affected but do not realize it.  Thank you.  

renatosteffen
5 - Atom

Is this still bugged ?

NickDelaby
5 - Atom

Did not receive any feedback / follow-up from Product Management at Alteryx, so I assume yes.

ptaylor_ds
6 - Meteoroid

I'm beginning to think they don't come out here looking for these things. 

Labels