# Percentiles and outliers **URL:** \ **Category:** Elasticsearch\ **Created:** [September 30, 2014, 6:01am UTC](https://discuss.elastic.co/t/percentiles-and-outliers/20010 "2014-09-30T06:01:17Z")\ **Posts on this page:** 3\ **Page:** 1
**Author:** ![liorg2](https://avatars.discourse-cdn.com/v4/letter/l/ed8c4c/32.png) [@liorg2](https://discuss.elastic.co/u/liorg2)\ **Post date:** [September 30, 2014, 6:01am UTC](https://discuss.elastic.co/t/percentiles-and-outliers/20010/1 "2014-09-30T06:01:17Z")
hi all, i'm trying to filter a search by 99 percentile, which for now i consider as outlier. currently i have 3 phases: 1. get all rows 2. calculate the 99 percentile for each row (by its key)- update the row with outlier=true or false 3. search again with filter "outlier=false" i'm looking for a more elegant way to do it.. thanks Lior -- You received this message because you are subscribed to the Google Groups "elasticsearch" group. To unsubscribe from this group and stop receiving emails from it, send an email to [elasticsearch+unsubscribe@googlegroups.com](mailto:elasticsearch+unsubscribe@googlegroups.com). To view this discussion on the web visit [https://groups.google.com/d/msgid/elasticsearch/b736aeb3-ae6d-49fc-805d-cd23a30e4879%40googlegroups.com](https://groups.google.com/d/msgid/elasticsearch/b736aeb3-ae6d-49fc-805d-cd23a30e4879%40googlegroups.com). For more options, visit [https://groups.google.com/d/optout](https://groups.google.com/d/optout). ---
**Author:** ![Jorge\_Luis\_Betancour](https://avatars.discourse-cdn.com/v4/letter/j/22d042/32.png) [@Jorge\_Luis\_Betancour](https://discuss.elastic.co/u/Jorge_Luis_Betancour)\ **Post date:** [October 1, 2014, 2:44am UTC](https://discuss.elastic.co/t/percentiles-and-outliers/20010/2 "2014-10-01T02:44:11Z")
Perhaps you could use the Percentile Aggregation? > **[Elasticsearch Platform — Find real-time answers at scale](https://www.elastic.co)** > > Power insights and outcomes with the Elasticsearch Platform and AI. See into your data and find answers that matter with enterprise solutions designed to help you build, observe, and protect. Try Elasticsearch free today. On Sep 30, 2014, at 2:01 AM, Lior Goldemberg [liorg2@gmail.com](mailto:liorg2@gmail.com) wrote: > hi all, > > i'm trying to filter a search by 99 percentile, which for now i consider as outlier. > currently i have 3 phases: > > get all rows > calculate the 99 percentile for each row (by its key)- update the row with outlier=true or false > search again with filter "outlier=false" > > i'm looking for a more elegant way to do it.. > > thanks > Lior > > -- > You received this message because you are subscribed to the Google Groups "elasticsearch" group. > To unsubscribe from this group and stop receiving emails from it, send an email to [elasticsearch+unsubscribe@googlegroups.com](mailto:elasticsearch+unsubscribe@googlegroups.com). > To view this discussion on the web visit [https://groups.google.com/d/msgid/elasticsearch/b736aeb3-ae6d-49fc-805d-cd23a30e4879%40googlegroups.com](https://groups.google.com/d/msgid/elasticsearch/b736aeb3-ae6d-49fc-805d-cd23a30e4879%40googlegroups.com). > For more options, visit [https://groups.google.com/d/optout](https://groups.google.com/d/optout). Concurso "Mi selfie por los 5". Detalles en [http://justiciaparaloscinco.wordpress.com](http://justiciaparaloscinco.wordpress.com) -- You received this message because you are subscribed to the Google Groups "elasticsearch" group. To unsubscribe from this group and stop receiving emails from it, send an email to [elasticsearch+unsubscribe@googlegroups.com](mailto:elasticsearch+unsubscribe@googlegroups.com). To view this discussion on the web visit [https://groups.google.com/d/msgid/elasticsearch/3A52B632-EC6A-4651-BA29-EA52CCB075DE%40uci.cu](https://groups.google.com/d/msgid/elasticsearch/3A52B632-EC6A-4651-BA29-EA52CCB075DE%40uci.cu). For more options, visit [https://groups.google.com/d/optout](https://groups.google.com/d/optout). ---
**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, 12:59am UTC](https://discuss.elastic.co/t/percentiles-and-outliers/20010/3 "2017-07-06T00:59:03Z")