Hello team, I am trying to understand that P90 Calculation in quicksight. I see different values when I calculate it manually or use excel.
In my understanding, generally calculation, values are first sorted in ASC and then you take the 90% of the count and then get that value. (If decimal then you round off and get the value).
Excel gives 98.6
Function: Percentile.inc( all the values selected, 0.9)
Manual calculation: 75 or 134
Calc: Sort t he values, 90% of 17(total values in dataset) = 15.3. So depending on round off you can pick 15 or 16 column value from sorted list or do an average of both
But in no calculation, I am getting ‘705’
0
8
5
0
45
40
75
0
16
1
134
29
27
705
0
1
33
Please help me understand the formula behind P90. Thank you