Allow integer fields in significant terms aggregation

[SebastienJn]

Kibana version: 6.6

In Kibana visualizations, would it be possible to have integer fields available for the significant terms aggregation ?

This is permitted by ES queries, the documentation specifies that only the floating point fields are not supported: search-aggregations-bucket-significantterms-aggregation.html.

The query generated by Kibana just works when changing the target field to an integer one manually (e.g. of type “long”).

[monfera]

Hello @SebastienJn it's more of a question so https://discuss.elastic.co/c/kibana would be the place to ask, as issues here are mostly for bugs, accessibility issues and feature requests.

[monfera]

@SebastienJn I'm reopening it as a feature request after a consultation

[elasticmachine]

Pinging @elastic/kibana-app

[timroes]

We need to extend the filter logic for field types a bit for that. Currently you can only specify a filter on the field parameter, for kibana field types. In Kibana we have only the numeric field type. Unfortunately the significant terms aggregation doesn't work with all ES field types, that we map to the numeric field type in Kibana (e.g. not with floating point ES field types). So that filter would need to be able to also filter on more than just the Kibana field type, but maybe also accept a function instead of a string which will get passed in the full field object and can then look into the ES field type in the information to filter for that.

[stratoula]

We are tracking the significant terms in other issue #116421