How to Kibana filter by percentile

[RDPanek (Radim Daniel Pánek)]

Hello everybody,
please help my with settings visualise for percentile aggregations.

I have Kibana 4.1.2 and I aggregation by 90% percentile by duration all my data in data table visualize. Results:

Headers:
filters | Top 2 endpoint | Top 2 ws | Count | Min | durationMax | duration | Average duration | 90th percentile of duration

And body:
system: abc | someEndpoint1 | someWS1 | 182,644 | 45| 7,898 | 240.514 | 189.813
system: xyz | someEndpoint2 | someWS2 | 182,644 | 45| 7,898 | 240.514 | 389.801

And i want in response only data, when 90% percentile will be greater than 200.

How do I do that? Thanks Daniel

[warkolm (Mark Walkom)]

Try using a filter on that field like `fieldname > 200".

[RDPanek (Radim Daniel Pánek)]

This isn't possible, because "filter" reduce set and then aggregation occurs.
So I need

1). step: aggregate all data

system: abc | someEndpoint1 | someWS1 | 182,644 | 45| 7,898 | 240.514 | 189.813 system: xyz | someEndpoint2 | someWS2 | 182,644 | 45| 7,898 | 240.514 | 389.801

2). step: view only records, which has 90% percentile will be greater than 200 ms.
it's obviously a filter, but I need filter after aggregation data.

[tbragin (Tanya Bragin)]

I don't believe this is possible right now. Feel free to file a feature request on Github: https://github.com/elastic/kibana/issues

[tbragin (Tanya Bragin)]

Depending on what you are doing, you may also consider Percentile Ranks, which would show you for each row, into what percentile 200ms falls.