# Unable to select keyword field for term aggregation

**URL:** https://discuss.elastic.co/t/unable-to-select-keyword-field-for-term-aggregation/283914
**Category:** Kibana
**Created:** [September 10, 2021, 7:45pm UTC](https://discuss.elastic.co/t/unable-to-select-keyword-field-for-term-aggregation/283914 "2021-09-10T19:45:40Z")
**Posts on this page:** 3
**Page:** 1

<div class="post-metadata">

### Author: ![adam3](https://avatars.discourse-cdn.com/v4/letter/a/dec6dc/32.png) [@adam3](https://discuss.elastic.co/u/adam3)
#### Post date: [September 10, 2021, 7:45pm UTC](https://discuss.elastic.co/t/unable-to-select-keyword-field-for-term-aggregation/283914/1 "2021-09-10T19:45:40Z")

</div>

Hey using 7.10.2 and I'm trying to make some visualizations. There are some fields that I can't select for term aggregations in charts etc. Not sure what I'm doing wrong.

 ![image](https://us1.discourse-cdn.com/elastic/original/3X/1/e/1e6acd8d36a0d284b8bea1ba323bad0c74c26a20.png)

But I've tried all sorts of mapping template settings to try and make it work.

Here are current index settings:

```auto
{
  "mappings": {
    "_doc": {
      "properties": {
        "date": {
          "type": "date"
        },
        "minutes": {
          "type": "double"
        },
        "mix": {
          "type": "keyword",
          "doc_values": false,
          "index_options": "freqs"
        },
        "mix_id": {
          "type": "keyword",
          "eager_global_ordinals": true
        },
        "region": {
          "type": "keyword",
          "store": true,
          "eager_global_ordinals": true
        },
        "user_id": {
          "type": "keyword"
        }
      }
    }
  }
}

```

I can see date and minutes (double) for terms aggregation, string fields \_id, \_index, \_type, but not region or mix or mix\_id (which I'd like to use). Do I need an upgrade?

Thanks,

Adam

---

<div class="post-metadata">

### Author: ![adam3](https://avatars.discourse-cdn.com/v4/letter/a/dec6dc/32.png) [@adam3](https://discuss.elastic.co/u/adam3)
#### Post date: [September 13, 2021, 5:55pm UTC](https://discuss.elastic.co/t/unable-to-select-keyword-field-for-term-aggregation/283914/2 "2021-09-13T17:55:45Z")

</div>

Ok so I upgraded to 7.14.1 and it's working now, good work, people.

---

<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: [October 11, 2021, 5:56pm UTC](https://discuss.elastic.co/t/unable-to-select-keyword-field-for-term-aggregation/283914/3 "2021-10-11T17:56:27Z")

</div>

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