How to get Count of order id within their percentile group in Webi?

[former_member665090]

Hi All,

I want to know how to get count of order ids within there percentile group in webi?

For example:

Result set - 0,0,0,0,0,0,1,2,2,3,5

total count - 11

25th Percentile - 0 Count of order_id - ?

50th Percentile - 0 Count of order_id - ?

80th Percentile - 1 Count of order_id - ?90th Percentile - 3 Count of order_id - ?95th Percentile - 4 Count of order_id - ?

So, basically I need the order id count. I am not sure how to get this in webi

I tried variable like:

=Count([order_id]) In ([25% of Result set])

=Count([order_id]) where ([Result set] <= [25% of Result set])

Any help is highly appreciated,

Thank you,

Regards,

Ahmed

[saurabh_sonawane]

Hi,

step 1 = get the count of order in my case it 11.

step 2 = get the count of all the variable

count = =Count([result set];All)

step 3 = how to get 25 percentile

25 percentile = 0.25*([count])

step4 = how to get 50 percentile

50 percentile = 0.50*([count])

step 5 = how to get 80 percentile

80 percentile = 0.80*([count])

step 95 = how to get 95 percentile

95 percentile = 0.95*([count])

[former_member665090]

Hi Saurabh,

Thank you for your help, could you please explain purpose of Test, Test1 and Count (what count is this). Let me explain once more what I need, I am calculating percentiles - 25th, 50th, 80th, 90th and 95th for the Result set which are in mins called Collected to Frist Received TAT, I need to find out how many tests comes under those percentile.

Refer the attached file:

Thanks,

Regards,

Ahmed

[saurabh_sonawane]

Hi

hope this formula will help you

Create detail variable base on the result set

test =RowIndex()+1

test1 = =((RowIndex()+1)/Max([test] In Report))*100

count =Max([test])In Report ( u can apply filter in this it will work )

note I had use slider(input control) instead of where clause.

Thanks