Problem with Term aggregation - Unable to use a specific field

Hi,

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,

Aurelien

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.