Forum Discussion
Matrix quartiles / percentiles
Hi,
I got data about time treatment and i calculate percentiles on it.
I use this : ROUNDDOWN(PERCENTILEX.INC('data_resultat';data_resultat[temps_affectation_realisation]; ,60);0)
I would like to make a matrix table with for each row a percentile and the calculate value associate to it but i don't find how to create in a matrix a specific column based on a measure (percentilex.inc)
What i want :
| Percentile | Treatment time |
| 25 % | 0d 0h 5min |
| 50 % | 0d 1h 5min |
| 60 % | 0d 2h 15min |
| 70 % | 0d 5h 50min |
Thanks
I find the solution.
Create a new data table insert values of percentile (25,50,60,70....) and add a new column with a function based on multiple if.
If column1 = 25% then PERCENTILEX.INC(....................)
1 Reply
I find the solution.
Create a new data table insert values of percentile (25,50,60,70....) and add a new column with a function based on multiple if.
If column1 = 25% then PERCENTILEX.INC(....................)