Terms agg: calculate aggs on 'other' bucket

[j0hnsmith]

The terms aggregation now provides an 'other' bucket with a count, I'd like to see the same aggregations performed on the 'other' bucket. Eg if I'm doing a stats aggregation I have stats (sum) for docs with term foo and bar but not for docs where the field is missing or has a null value.

This is really important for analytics type services as all the values must add up to 100% of the total.

There's quite a bit of discussion about it in #5324.

[clintongormley]

@j0hnsmith calculating sub-aggs on an other bucket requires two round trips. The first calculates the top-ten terms (plus their sub-aggs). The second calculates the sub-aggs on everything except the top-ten terms.

To support this in Elasticsearch, we'd need to implement #12316 first. However this is something you can do yourself today.

[j0hnsmith]

I know there are workarounds, but with every level of sub aggregation they get progressively more complex, this could simplify some very complex queries.

[vivekmoosani]

+1

[PaulGrandperrin]

+1

[powermik]

+1

[dynomeat]

+1

[EdwardKaravakis]

+1