Skip to Content
0
Oct 16, 2019 at 08:45 PM

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

202 Views

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