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.
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.