# How to Kibana filter by percentile

**URL:** <https://discuss.elastic.co/t/how-to-kibana-filter-by-percentile/28435>\
**Category:** Kibana\
**Created:** [September 1, 2015, 1:37pm UTC](https://discuss.elastic.co/t/how-to-kibana-filter-by-percentile/28435 "2015-09-01T13:37:18Z")\
**Posts on this page:** 6\
**Page:** 1

<div class="post-metadata">

**Author:** ![RDPanek](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/rdpanek/32/4514_2.png) [@RDPanek](https://discuss.elastic.co/u/RDPanek)\
**Post date:** [September 1, 2015, 1:37pm UTC](https://discuss.elastic.co/t/how-to-kibana-filter-by-percentile/28435/1 "2015-09-01T13:37:18Z")

</div>

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

---

<div class="post-metadata">

**Author:** ![warkolm](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/warkolm/32/39224_2.png) [@warkolm](https://discuss.elastic.co/u/warkolm)\
**Post date:** [September 2, 2015, 1:16am UTC](https://discuss.elastic.co/t/how-to-kibana-filter-by-percentile/28435/2 "2015-09-02T01:16:26Z")

</div>

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

---

<div class="post-metadata">

**Author:** ![RDPanek](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/rdpanek/32/4514_2.png) [@RDPanek](https://discuss.elastic.co/u/RDPanek)\
**Post date:** [September 2, 2015, 6:38am UTC](https://discuss.elastic.co/t/how-to-kibana-filter-by-percentile/28435/3 "2015-09-02T06:38:23Z")

</div>

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.

---

<div class="post-metadata">

**Author:** ![tbragin](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/tbragin/32/45166_2.png) [@tbragin](https://discuss.elastic.co/u/tbragin)\
**Post date:** [September 10, 2015, 10:05pm UTC](https://discuss.elastic.co/t/how-to-kibana-filter-by-percentile/28435/4 "2015-09-10T22:05:35Z")

</div>

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

---

<div class="post-metadata">

**Author:** ![tbragin](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/tbragin/32/45166_2.png) [@tbragin](https://discuss.elastic.co/u/tbragin)\
**Post date:** [September 11, 2015, 2:40am UTC](https://discuss.elastic.co/t/how-to-kibana-filter-by-percentile/28435/5 "2015-09-11T02:40:58Z")

</div>

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

 ![](https://us1.discourse-cdn.com/elastic/original/2X/0/0784f7d3b25d7a5145a62c6d3834651a9dc09296.png)

---

<div class="post-metadata">

**Author:** ![system](https://us1.discourse-cdn.com/elastic/original/3X/1/a/1ac57faf039f6b580b3f104ef42a2a89e41014de.png) [@system](https://discuss.elastic.co/u/system)\
**Post date:** [July 6, 2017, 2:13pm UTC](https://discuss.elastic.co/t/how-to-kibana-filter-by-percentile/28435/6 "2017-07-06T14:13:21Z")

</div>