# Facets and "Other"

**URL:** <https://discuss.elastic.co/t/facets-and-other/11416>\
**Category:** Elasticsearch\
**Created:** [April 2, 2013, 4:46pm UTC](https://discuss.elastic.co/t/facets-and-other/11416 "2013-04-02T16:46:57Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![pr2012](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/pr2012/32/2186_2.png) [@pr2012](https://discuss.elastic.co/u/pr2012)\
**Post date:** [April 2, 2013, 4:46pm UTC](https://discuss.elastic.co/t/facets-and-other/11416/1 "2013-04-02T16:46:57Z")

</div>

I am getting facet counts with a query across 6 indexes for a field that  
should always be a string, and as far as I know, it is. There are about  
13million documents.

However my facet results include a very high count (6mil+) for "Other". How  
can I enumerate some of the values for "Other" or at least do a query to  
list the docs?

thx!

{  
"query" : {  
"match\_all" : { }  
},  
"facets" : {  
"page\_ids" : {  
"terms" : {  
"field" : "page\_id",  
"size" : 10  
}  
}  
},  
"size":1  
}

--  
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).

---

<div class="post-metadata">

**Author:** ![Ivan](https://avatars.discourse-cdn.com/v4/letter/i/df788c/32.png) [@Ivan](https://discuss.elastic.co/u/Ivan)\
**Post date:** [April 3, 2013, 5:30pm UTC](https://discuss.elastic.co/t/facets-and-other/11416/2 "2013-04-03T17:30:59Z")

</div>

The number of facet entries returned is limited by the size field. Any  
document not within the first 10 (in your case) facets will be placed in  
Other. If you require more values, increase the size.

--  
Ivan

On Tue, Apr 2, 2013 at 9:46 AM, ES\_Newb [phill.rosen@gmail.com](mailto:phill.rosen@gmail.com) wrote:

> I am getting facet counts with a query across 6 indexes for a field that  
> should always be a string, and as far as I know, it is. There are about  
> 13million documents.
> 
> However my facet results include a very high count (6mil+) for "Other".  
> How can I enumerate some of the values for "Other" or at least do a query  
> to list the docs?
> 
> thx!
> 
> {  
> "query" : {  
> "match\_all" : { }  
> },  
> "facets" : {  
> "page\_ids" : {  
> "terms" : {  
> "field" : "page\_id",  
> "size" : 10  
> }  
> }  
> },  
> "size":1  
> }
> 
> --  
> 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).

---

<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:42am UTC](https://discuss.elastic.co/t/facets-and-other/11416/3 "2017-07-06T02:42:59Z")

</div>

Closed on July 6, 2017, 2:42am UTC