Per the definition provided here percentileCont - Amazon QuickSight , the percentile cont function is supposed to interpolate the values based on a continuous distribution. However, it is operating similar to percentile_disc and taking the discrete value corresponding to the distribution.
In the attached example, based on the data distribution, the 90th percentile (using percentile_cont) should be at 44.43.
However, the percentile_cont is computing the 90th percentile to be 26.07 which is based on a discrete distribution. Attached screenshot below. The ‘time’ calculation uses the ‘percentile’ aggregate function available in the Pivot ‘Values’ section. The p90_cont is a calculated field that uses the continuous distribution function and p90_disc uses the discrete distribution function
Below is the calculation applied for percentileCont (p90_cont variable). We are not using percentileContOver since we require the p90 calculations to be done dynamically based on the level of aggregation selected (country/country+business_line/country+business_line+metric).
Please cross check your data and calcs. If you still believe there to be an issue with the calcs afterwards, I would recommend filing a case with AWS Support where we can dive into the details so that we can help you further. Here are the steps to open a support case. If your company has someone who manages your AWS account, you might not have direct access to AWS Support and will need to raise an internal ticket to your IT team or whomever manages your AWS account. They should be able to open an AWS Support case on your behalf.
