Skip to Content
0

How to do percentile calculation in webi 4.1

Jul 12, 2017 at 05:07 PM

135

avatar image
Former Member

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

10 |10000 characters needed characters left characters exceeded

Can you share the sample data image.

0
Former Member

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

problemsnap.jpg (94.9 kB)
0
Former Member

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

image1.jpg (212.9 kB)
snap-2.jpg (44.8 kB)
snap-3.jpg (77.5 kB)
snap-4.jpg (35.9 kB)
0
* Please Login or Register to Answer, Follow or Comment.

1 Answer

Best Answer
avatar image
Former Member Jul 28, 2017 at 12:10 PM
0

The issue has been resolved

Share
10 |10000 characters needed characters left characters exceeded