Problem with Term aggregation - Unable to use a specific field

[aurelien]

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

[Larry_Gregory]

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:

[aurelien]

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