This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
Early bird tickets for Inspire 2023 are now available! Discounted pricing closes on January 31st. Save your spot!
We have recently upgraded to Alteryx Designer x64 Version: 2022.1.1.25127.
I have found an issue when calculating percentiles using the summarize tool on large data sets.
In the attached workflow, I generate some long arithmetic sequences and then use the summarize tool to find the 50th percentile (median).
With the AMP engine turned on, a lot of these percentiles come out to the wrong values. What seems to be happening is that the correct percentile from one group is being outputted as the percentile for multiple groups. All these percentiles should be distinct and yet:
I turn the AMP engine off and the issue goes away.
Wonder if this is an issue any one else has had and if it can be fixed/there is a workaround.
Thanks for the guidance Tonya. I turned off the AMP as you instructed, and now I am getting consistent results. Thanks again, for the help...I was going crazy!
BTW, when will 2022.3 be available?
We cannot disclose dates, but it is the final release of the 2022 year so definitely expected to be available before the end of the year.