cancel
Showing results for 
Search instead for 
Did you mean: 

How to do percentile calculation in webi 4.1

Former Member
0 Kudos
1,277

I am stuck in this for over a week and I need to get over this. I have a measure "TAT" that shows the turn around times of over 10000 applications, but now I want to apply aggregate function(average) on top 90% of the values only(which would give me the average of least TAT). Can anyone help me out on this. I have tried ranking but that enables me to have that only with a dimension along with it such as application id. Is there any way by which I can have the required average in another variable, so that I can easily use it. Thanks in advance

amitrathi239
Active Contributor
0 Kudos

Can you share the sample data image.

Former Member
0 Kudos

Encircled fields are the required ones. I wish to create variables that calculate the corresponding results.

Former Member
0 Kudos

I can achieve this through ranking. But that doesnot allow me to sync my data in this report. Go through the images according to their serial numbers.image1.jpgsnap-2.jpg snap-3.jpgsnap-4.jpg

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

The issue has been resolved

Answers (0)