Hi, I have got 90 percentile calculating the date diff of 2 dates but the percentile is not matching with the tableau’s and when I am selecting show total of row option that is not giving me the correct percentile of 3 rows, can someone please help?

Hi @Nisha - I took the data for Quick Sight and calculate the 90th Percentile ( use the function - percentileCont) and it gave me the value as 13.1 which is also matching with excel data. There is no issue with Quick Sight. Can you please check for these data, how come Tableau providing other value. …

Incorrect percentile when compared to tableau

Q&A

Sanjeeb2022 June 4, 2024, 4:52pm 6

Hi @Nisha - You can cast the field as float in Quick Sight. See one reference for the same.

Regards - Sanjeeb

Topic		Replies	Views
Percentile Rank Q&A calculations	14	916	September 25, 2023
Return specific percentiles of an array in a table in Quicksight - Like Pandas Describe Function Q&A analysis , calculations	12	3562	January 5, 2022
How to fix the grain of percentile calculation in quicksight? Q&A developer , qls-community	1	28	March 17, 2025
Do we have support for weighted percentile in Quick Sight? Q&A calculations , Business-Intelligence-Engineer	3	41	July 20, 2025
Conditional Formating Percentile Q&A formulas , feature-request , calculations , Business-Intelligence-Engineer	7	160	May 24, 2024

Incorrect percentile when compared to tableau

Related topics