# Multi terms aggregation

**URL:** <https://discuss.elastic.co/t/multi-terms-aggregation/304345>\
**Category:** Elasticsearch\
**Tags:** vega\
**Created:** [May 10, 2022, 1:04pm UTC](https://discuss.elastic.co/t/multi-terms-aggregation/304345 "2022-05-10T13:04:35Z")\
**Posts on this page:** 7\
**Page:** 1

<div class="post-metadata">

**Author:** ![meyer1](https://avatars.discourse-cdn.com/v4/letter/m/b487fb/32.png) [@meyer1](https://discuss.elastic.co/u/meyer1)\
**Post date:** [May 10, 2022, 1:04pm UTC](https://discuss.elastic.co/t/multi-terms-aggregation/304345/1 "2022-05-10T13:04:35Z")

</div>

Hello everyone, I need help with an elastic query.

My current query is:

```auto
{
  "size" : 1,
  "aggs": {
    "NAME": {
      "multi_terms": {
        "terms": [{
          "field": "fieldName1.keyword"
        }, {
          "field": "fieldName2Name.keyword"
        }, {
          "field": "fieldName3.keyword"
        }]
      }
    }
  }
}

```

I would like to increase "size" which is 10 by default, how should I do? Where should I place it in my query?  
and I would like to display the most recent element (I have an eventDate for each of my documents) and display it from my bucket.  
My goal is to use this query in a Vega Table type visualization

Thank you in advance for your answers

---

<div class="post-metadata">

**Author:** ![RabBit\_BR](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/rabbit_br/32/82261_2.png) [@RabBit\_BR](https://discuss.elastic.co/u/RabBit_BR)\
**Post date:** [May 10, 2022, 1:43pm UTC](https://discuss.elastic.co/t/multi-terms-aggregation/304345/2 "2022-05-10T13:43:01Z")

</div>

Hi!!

> [@meyer1](#):
>
> Gostaria de aumentar o "tamanho" que é 10 por padrão, como devo fazer? Onde devo colocá-lo na minha consulta?

> **[Terms aggregation | Elasticsearch Guide \[8.11\] | Elastic](https://www.elastic.co/guide/en/elasticsearch/reference/current/search-aggregations-bucket-terms-aggregation.html#search-aggregations-bucket-terms-aggregation-size)**

---

<div class="post-metadata">

**Author:** ![meyer1](https://avatars.discourse-cdn.com/v4/letter/m/b487fb/32.png) [@meyer1](https://discuss.elastic.co/u/meyer1)\
**Post date:** [May 10, 2022, 1:50pm UTC](https://discuss.elastic.co/t/multi-terms-aggregation/304345/3 "2022-05-10T13:50:17Z")

</div>

Thank you for your answer, I have already read this passage but it does not help me.. I still do not know where to put "size"..

---

<div class="post-metadata">

**Author:** ![RabBit\_BR](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/rabbit_br/32/82261_2.png) [@RabBit\_BR](https://discuss.elastic.co/u/RabBit_BR)\
**Post date:** [May 10, 2022, 1:57pm UTC](https://discuss.elastic.co/t/multi-terms-aggregation/304345/4 "2022-05-10T13:57:31Z")

</div>

```auto
 "multi_terms": {
        **"size":12,**
        "terms": [
           .....
        ]
      }

```

---

<div class="post-metadata">

**Author:** ![meyer1](https://avatars.discourse-cdn.com/v4/letter/m/b487fb/32.png) [@meyer1](https://discuss.elastic.co/u/meyer1)\
**Post date:** [May 12, 2022, 12:14pm UTC](https://discuss.elastic.co/t/multi-terms-aggregation/304345/5 "2022-05-12T12:14:05Z")

</div>

thank you for your answer, is it possible to add a "value\_count" to this? I would like to add it to count the distinct values in fieldName3

---

<div class="post-metadata">

**Author:** ![Tomo\_M](https://avatars.discourse-cdn.com/v4/letter/t/848f3c/32.png) [@Tomo\_M](https://discuss.elastic.co/u/Tomo_M)\
**Post date:** [May 13, 2022, 7:01am UTC](https://discuss.elastic.co/t/multi-terms-aggregation/304345/6 "2022-05-13T07:01:17Z")

</div>

Hi, maybe you need cardinality aggregation to count values.

---

<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:** [June 10, 2022, 7:01am UTC](https://discuss.elastic.co/t/multi-terms-aggregation/304345/7 "2022-06-10T07:01:24Z")

</div>

This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.