# Faceting and filter on aggregated values **URL:** \ **Category:** Elasticsearch\ **Created:** [July 8, 2013, 9:19am UTC](https://discuss.elastic.co/t/faceting-and-filter-on-aggregated-values/12692 "2013-07-08T09:19:30Z")\ **Posts on this page:** 9\ **Page:** 1
**Author:** ![Amit](https://avatars.discourse-cdn.com/v4/letter/a/ee7513/32.png) [@Amit](https://discuss.elastic.co/u/Amit)\ **Post date:** [July 8, 2013, 9:19am UTC](https://discuss.elastic.co/t/faceting-and-filter-on-aggregated-values/12692/1 "2013-07-08T09:19:30Z")
Hi All, Is there a way that the filter can be applied on the aggregated values. My requirement is to apply filter on aggregated values; example; list all cities with mobile\_sales greater than 5,000. I can do this by TermsStatsFacetBuilder, where my key field is city and value field is mobile\_sales. But I cannot apply the filter on the aggregated values of mobile\_sales. The filter will be applied at the record/row level of mobile\_sales. It there a way or workaround for this. Or is this something that I need to tweak in elastic search? Thanks Amit -- 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). For more options, visit [https://groups.google.com/groups/opt\_out](https://groups.google.com/groups/opt_out). ---
**Author:** ![Amit](https://avatars.discourse-cdn.com/v4/letter/a/ee7513/32.png) [@Amit](https://discuss.elastic.co/u/Amit)\ **Post date:** [July 8, 2013, 6:24pm UTC](https://discuss.elastic.co/t/faceting-and-filter-on-aggregated-values/12692/2 "2013-07-08T18:24:22Z")
I was able to figure out this one. The facet class give you the handle to apply the logic at the aggregation level on terms. @Override ``` *public* Facet reduce(List facets) ``` Here all the data from respective shards is merged to get the final output. The logic can be applied here,to apply the filter on aggregated values. But this solution would require changing the Elasticsearch code. And I do not want to modify the existing Elasticsearch code. Any other option or way of achieving this? Thanks Amit On Monday, July 8, 2013 2:49:30 PM UTC+5:30, Amit Singh wrote: > Hi All, > > Is there a way that the filter can be applied on the aggregated values. > > My requirement is to apply filter on aggregated values; > example; > > list all cities with mobile\_sales greater than 5,000. > I can do this by TermsStatsFacetBuilder, where my key field is city and > value field is mobile\_sales. > > But I cannot apply the filter on the aggregated values of mobile\_sales. > The filter will be applied at the record/row level of mobile\_sales. > > It there a way or workaround for this. Or is this something that I need to > tweak in Elasticsearch? > > Thanks > Amit -- 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). For more options, visit [https://groups.google.com/groups/opt\_out](https://groups.google.com/groups/opt_out). ---
**Author:** ![Boaz\_Leskes](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/boaz_leskes/32/723_2.png) [@Boaz\_Leskes](https://discuss.elastic.co/u/Boaz_Leskes)\ **Post date:** [July 9, 2013, 12:22pm UTC](https://discuss.elastic.co/t/faceting-and-filter-on-aggregated-values/12692/3 "2013-07-09T12:22:37Z")
Hi Amit, This is something you currently need to do in your application layer or indeed write a custom facet. Pretty sure you know, but if you are only interested in a great-than filtering, you can sort the term stat's response by total (in you example, the sum of mobile\_sales) and ignore all the entries (cities) bellow your threshold. Cheers, Boaz On Monday, July 8, 2013 8:24:22 PM UTC+2, Amit Singh wrote: > I was able to figure out this one. > > The facet class give you the handle to apply the logic at the aggregation > level on terms. > > @Override > > ``` > *public* Facet reduce(List facets) > > ``` > > Here all the data from respective shards is merged to get the final > output. The logic can be applied here,to apply the filter on aggregated > values. > > But this solution would require changing the Elasticsearch code. And I do > not want to modify the existing Elasticsearch code. > > Any other option or way of achieving this? > > Thanks > > Amit > > On Monday, July 8, 2013 2:49:30 PM UTC+5:30, Amit Singh wrote: > > > Hi All, > > > > Is there a way that the filter can be applied on the aggregated values. > > > > My requirement is to apply filter on aggregated values; > > example; > > > > list all cities with mobile\_sales greater than 5,000. > > I can do this by TermsStatsFacetBuilder, where my key field is city and > > value field is mobile\_sales. > > > > But I cannot apply the filter on the aggregated values of mobile\_sales. > > The filter will be applied at the record/row level of mobile\_sales. > > > > It there a way or workaround for this. Or is this something that I need > > to tweak in Elasticsearch? > > > > Thanks > > Amit -- 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). For more options, visit [https://groups.google.com/groups/opt\_out](https://groups.google.com/groups/opt_out). ---
**Author:** ![Ban\_Mido](https://avatars.discourse-cdn.com/v4/letter/b/dec6dc/32.png) [@Ban\_Mido](https://discuss.elastic.co/u/Ban_Mido)\ **Post date:** [July 11, 2013, 7:31pm UTC](https://discuss.elastic.co/t/faceting-and-filter-on-aggregated-values/12692/4 "2013-07-11T19:31:10Z")
@Amit - This is what you are looking for - > **[GitHub - imotov/elasticsearch-facet-script: Fully Scriptable Facets for...](https://github.com/imotov/elasticsearch-facet-script)** > > Fully Scriptable Facets for ElasticSearch. Contribute to imotov/elasticsearch-facet-script development by creating an account on GitHub. You can write your custom aggregation logic using this. ~Ban On Tue, Jul 9, 2013 at 5:52 PM, Boaz Leskes [b.leskes@gmail.com](mailto:b.leskes@gmail.com) wrote: > Hi Amit, > > This is something you currently need to do in your application layer or > indeed write a custom facet. > > Pretty sure you know, but if you are only interested in a great-than > filtering, you can sort the term stat's response by total (in you example, > the sum of mobile\_sales) and ignore all the entries (cities) bellow your > threshold. > > Cheers, > Boaz > > On Monday, July 8, 2013 8:24:22 PM UTC+2, Amit Singh wrote: > > > I was able to figure out this one. > > > > The facet class give you the handle to apply the logic at the aggregation > > level on terms. > > > > @Override > > > > ``` > > *public* Facet reduce(List facets) > > > > ``` > > > > Here all the data from respective shards is merged to get the final > > output. The logic can be applied here,to apply the filter on aggregated > > values. > > > > But this solution would require changing the Elasticsearch code. And I > > do not want to modify the existing Elasticsearch code. > > > > Any other option or way of achieving this? > > > > Thanks > > > > Amit > > > > On Monday, July 8, 2013 2:49:30 PM UTC+5:30, Amit Singh wrote: > > > > > Hi All, > > > > > > Is there a way that the filter can be applied on the aggregated values. > > > > > > My requirement is to apply filter on aggregated values; > > > example; > > > > > > list all cities with mobile\_sales greater than 5,000. > > > I can do this by TermsStatsFacetBuilder, where my key field is city and > > > value field is mobile\_sales. > > > > > > But I cannot apply the filter on the aggregated values of mobile\_sales. > > > The filter will be applied at the record/row level of mobile\_sales. > > > > > > It there a way or workaround for this. Or is this something that I need > > > to tweak in Elasticsearch? > > > > > > Thanks > > > Amit > > > > > > -- > > > 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). > > > For more options, visit [https://groups.google.com/groups/opt\_out](https://groups.google.com/groups/opt_out). -- 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). For more options, visit [https://groups.google.com/groups/opt\_out](https://groups.google.com/groups/opt_out). ---
**Author:** ![kajal](https://avatars.discourse-cdn.com/v4/letter/k/7993a0/32.png) [@kajal](https://discuss.elastic.co/u/kajal)\ **Post date:** [July 15, 2013, 6:29pm UTC](https://discuss.elastic.co/t/faceting-and-filter-on-aggregated-values/12692/5 "2013-07-15T18:29:36Z")
Amit, do you able to solve this? I am into the same problem. I need to filter facet result based on the aggregrated value. ---
**Author:** ![kajal](https://avatars.discourse-cdn.com/v4/letter/k/7993a0/32.png) [@kajal](https://discuss.elastic.co/u/kajal)\ **Post date:** [July 16, 2013, 2:50pm UTC](https://discuss.elastic.co/t/faceting-and-filter-on-aggregated-values/12692/6 "2013-07-16T14:50:10Z")
@Amit, do you able to solve this? I am into the same problem. I need to filter facet result based on the aggregated value. On Thursday, July 11, 2013 3:31:10 PM UTC-4, Ban Mido wrote: > @Amit - > > This is what you are looking for - > [GitHub - imotov/elasticsearch-facet-script: Fully Scriptable Facets for ElasticSearch](https://github.com/imotov/elasticsearch-facet-script) > You can write your custom aggregation logic using this. > > ~Ban > > On Tue, Jul 9, 2013 at 5:52 PM, Boaz Leskes \<[b.le...@gmail.com](mailto:b.le...@gmail.com)\ > > > wrote: > > > Hi Amit, > > > > This is something you currently need to do in your application layer or > > indeed write a custom facet. > > > > Pretty sure you know, but if you are only interested in a great-than > > filtering, you can sort the term stat's response by total (in you example, > > the sum of mobile\_sales) and ignore all the entries (cities) bellow your > > threshold. > > > > Cheers, > > Boaz > > > > On Monday, July 8, 2013 8:24:22 PM UTC+2, Amit Singh wrote: > > > > > I was able to figure out this one. > > > > > > The facet class give you the handle to apply the logic at the > > > aggregation level on terms. > > > > > > @Override > > > > > > ``` > > > *public* Facet reduce(List facets) > > > > > > ``` > > > > > > Here all the data from respective shards is merged to get the final > > > output. The logic can be applied here,to apply the filter on aggregated > > > values. > > > > > > But this solution would require changing the Elasticsearch code. And I > > > do not want to modify the existing Elasticsearch code. > > > > > > Any other option or way of achieving this? > > > > > > Thanks > > > > > > Amit > > > > > > On Monday, July 8, 2013 2:49:30 PM UTC+5:30, Amit Singh wrote: > > > > > > > Hi All, > > > > > > > > Is there a way that the filter can be applied on the aggregated values. > > > > > > > > My requirement is to apply filter on aggregated values; > > > > example; > > > > > > > > list all cities with mobile\_sales greater than 5,000. > > > > I can do this by TermsStatsFacetBuilder, where my key field is city > > > > and value field is mobile\_sales. > > > > > > > > But I cannot apply the filter on the aggregated values of mobile\_sales. > > > > The filter will be applied at the record/row level of mobile\_sales. > > > > > > > > It there a way or workaround for this. Or is this something that I need > > > > to tweak in Elasticsearch? > > > > > > > > Thanks > > > > Amit > > > > > > > > -- > > > > 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 [elasticsearc...@googlegroups.com](mailto:elasticsearc...@googlegroups.com) \. > > > > For more options, visit [https://groups.google.com/groups/opt\_out](https://groups.google.com/groups/opt_out). -- 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). For more options, visit [https://groups.google.com/groups/opt\_out](https://groups.google.com/groups/opt_out). ---
**Author:** ![Amit](https://avatars.discourse-cdn.com/v4/letter/a/ee7513/32.png) [@Amit](https://discuss.elastic.co/u/Amit)\ **Post date:** [July 16, 2013, 3:20pm UTC](https://discuss.elastic.co/t/faceting-and-filter-on-aggregated-values/12692/7 "2013-07-16T15:20:29Z")
Hi Kajal, I was able to build a plugin based faceting , and apply custom logic in facet. Go through the different links provided by the group members. You should be able to achieve it. Thanks Amit On Tue, Jul 16, 2013 at 8:20 PM, Kajal Patel [kajal23@gmail.com](mailto:kajal23@gmail.com) wrote: > @Amit, > do you able to solve this? I am into the same problem. I need to filter > facet result based on the aggregated value. > > On Thursday, July 11, 2013 3:31:10 PM UTC-4, Ban Mido wrote: > > > @Amit - > > > > This is what you are looking for - [imotov (Igor Motov) · GitHub](https://github.com/imotov/)\*\* > > elasticsearch-facet-script[https://github.com/imotov/elasticsearch-facet-script](https://github.com/imotov/elasticsearch-facet-script) > > You can write your custom aggregation logic using this. > > > > ~Ban > > > > On Tue, Jul 9, 2013 at 5:52 PM, Boaz Leskes [b.le...@gmail.com](mailto:b.le...@gmail.com) wrote: > > > > > Hi Amit, > > > > > > This is something you currently need to do in your application layer or > > > indeed write a custom facet. > > > > > > Pretty sure you know, but if you are only interested in a great-than > > > filtering, you can sort the term stat's response by total (in you example, > > > the sum of mobile\_sales) and ignore all the entries (cities) bellow your > > > threshold. > > > > > > Cheers, > > > Boaz > > > > > > On Monday, July 8, 2013 8:24:22 PM UTC+2, Amit Singh wrote: > > > > > > > I was able to figure out this one. > > > > > > > > The facet class give you the handle to apply the logic at the > > > > aggregation level on terms. > > > > > > > > @Override > > > > > > > > ``` > > > > *public* Facet reduce(List facets) > > > > > > > > ``` > > > > > > > > Here all the data from respective shards is merged to get the final > > > > output. The logic can be applied here,to apply the filter on > > > > aggregated values. > > > > > > > > But this solution would require changing the Elasticsearch code. And I > > > > do not want to modify the existing Elasticsearch code. > > > > > > > > Any other option or way of achieving this? > > > > > > > > Thanks > > > > > > > > Amit > > > > > > > > On Monday, July 8, 2013 2:49:30 PM UTC+5:30, Amit Singh wrote: > > > > > > > > > Hi All, > > > > > > > > > > Is there a way that the filter can be applied on the aggregated values. > > > > > > > > > > My requirement is to apply filter on aggregated values; > > > > > example; > > > > > > > > > > list all cities with mobile\_sales greater than 5,000. > > > > > I can do this by TermsStatsFacetBuilder, where my key field is city > > > > > and value field is mobile\_sales. > > > > > > > > > > But I cannot apply the filter on the aggregated values of > > > > > mobile\_sales. The filter will be applied at the record/row level of > > > > > mobile\_sales. > > > > > > > > > > It there a way or workaround for this. Or is this something that I > > > > > need to tweak in Elasticsearch? > > > > > > > > > > Thanks > > > > > Amit > > > > > > > > > > -- > > > > > 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 elasticsearc...@\*\*[googlegroups.com](http://googlegroups.com). > > > > > > For more options, visit [https://groups.google.com/\*\*groups/opt\_out](https://groups.google.com/**groups/opt_out)[https://groups.google.com/groups/opt\_out](https://groups.google.com/groups/opt_out) > > > . > > > > -- > > 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). > > For more options, visit [https://groups.google.com/groups/opt\_out](https://groups.google.com/groups/opt_out). -- 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). For more options, visit [https://groups.google.com/groups/opt\_out](https://groups.google.com/groups/opt_out). ---
**Author:** ![kajal](https://avatars.discourse-cdn.com/v4/letter/k/7993a0/32.png) [@kajal](https://discuss.elastic.co/u/kajal)\ **Post date:** [July 16, 2013, 4:11pm UTC](https://discuss.elastic.co/t/faceting-and-filter-on-aggregated-values/12692/8 "2013-07-16T16:11:00Z")
Amit, thanks for your reply. Is your plugin available for public?? Also, did you try facet scripting for the same problem? On Tuesday, July 16, 2013 11:20:29 AM UTC-4, Amit Singh wrote: > Hi Kajal, > > I was able to build a plugin based faceting , and apply custom logic in > facet. > > Go through the different links provided by the group members. You should > be able to achieve it. > > Thanks > Amit > > On Tue, Jul 16, 2013 at 8:20 PM, Kajal Patel \<[kaj...@gmail.com](mailto:kaj...@gmail.com)\ > > > wrote: > > > @Amit, > > do you able to solve this? I am into the same problem. I need to filter > > facet result based on the aggregated value. > > > > On Thursday, July 11, 2013 3:31:10 PM UTC-4, Ban Mido wrote: > > > > > @Amit - > > > > > > This is what you are looking for - [imotov (Igor Motov) · GitHub](https://github.com/imotov/)\*\* > > > elasticsearch-facet-script[https://github.com/imotov/elasticsearch-facet-script](https://github.com/imotov/elasticsearch-facet-script) > > > You can write your custom aggregation logic using this. > > > > > > ~Ban > > > > > > On Tue, Jul 9, 2013 at 5:52 PM, Boaz Leskes [b.le...@gmail.com](mailto:b.le...@gmail.com) wrote: > > > > > > > Hi Amit, > > > > > > > > This is something you currently need to do in your application layer or > > > > indeed write a custom facet. > > > > > > > > Pretty sure you know, but if you are only interested in a great-than > > > > filtering, you can sort the term stat's response by total (in you example, > > > > the sum of mobile\_sales) and ignore all the entries (cities) bellow your > > > > threshold. > > > > > > > > Cheers, > > > > Boaz > > > > > > > > On Monday, July 8, 2013 8:24:22 PM UTC+2, Amit Singh wrote: > > > > > > > > > I was able to figure out this one. > > > > > > > > > > The facet class give you the handle to apply the logic at the > > > > > aggregation level on terms. > > > > > > > > > > @Override > > > > > > > > > > ``` > > > > > *public* Facet reduce(List facets) > > > > > > > > > > ``` > > > > > > > > > > Here all the data from respective shards is merged to get the final > > > > > output. The logic can be applied here,to apply the filter on > > > > > aggregated values. > > > > > > > > > > But this solution would require changing the Elasticsearch code. And > > > > > I do not want to modify the existing Elasticsearch code. > > > > > > > > > > Any other option or way of achieving this? > > > > > > > > > > Thanks > > > > > > > > > > Amit > > > > > > > > > > On Monday, July 8, 2013 2:49:30 PM UTC+5:30, Amit Singh wrote: > > > > > > > > > > > Hi All, > > > > > > > > > > > > Is there a way that the filter can be applied on the aggregated > > > > > > values. > > > > > > > > > > > > My requirement is to apply filter on aggregated values; > > > > > > example; > > > > > > > > > > > > list all cities with mobile\_sales greater than 5,000. > > > > > > I can do this by TermsStatsFacetBuilder, where my key field is city > > > > > > and value field is mobile\_sales. > > > > > > > > > > > > But I cannot apply the filter on the aggregated values of > > > > > > mobile\_sales. The filter will be applied at the record/row level of > > > > > > mobile\_sales. > > > > > > > > > > > > It there a way or workaround for this. Or is this something that I > > > > > > need to tweak in Elasticsearch? > > > > > > > > > > > > Thanks > > > > > > Amit > > > > > > > > > > > > -- > > > > > > 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 elasticsearc...@\*\*[googlegroups.com](http://googlegroups.com). > > > > > > > > For more options, visit [https://groups.google.com/\*\*groups/opt\_out](https://groups.google.com/**groups/opt_out)[https://groups.google.com/groups/opt\_out](https://groups.google.com/groups/opt_out) > > > > . > > > > > > -- > > > 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 [elasticsearc...@googlegroups.com](mailto:elasticsearc...@googlegroups.com) \. > > > For more options, visit [https://groups.google.com/groups/opt\_out](https://groups.google.com/groups/opt_out). -- 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). For more options, visit [https://groups.google.com/groups/opt\_out](https://groups.google.com/groups/opt_out). ---
**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:26am UTC](https://discuss.elastic.co/t/faceting-and-filter-on-aggregated-values/12692/9 "2017-07-06T02:26:10Z")