Problem with Term aggregation - Unable to use a specific field


I want to use a simple Term aggregation in a data table but I have a problem with the Field selector. The field that I want to use for aggregation is not in the dropdown list. However, the aggregation works perfectly if I query elasticsearch directly:

GET /entities/_search
"size": 0,
"aggs": {
"category": {
"terms": {
"field": "Cat_EN.keyword",
"size": 10

I use the latest version (6.4.0) of ES and Kibana.

Do you have any idea on what is going wrong?

Thank you,


Is is possible that your index pattern is out-of-date? If your mapping changed after creating the index pattern (for example, if Cat_EN didn't used to have a "keyword" field), then Kibana won't be aware of that.

Refreshing the index pattern from the management screen might help if that's the case:

1 Like

Yes it worked :-). Thank you very much!

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