Search code examples
elasticsearchkibanakibana-4

Kibana. Data tables. Exclude terms depending on the length

I'm storing sentences in Elasticsearch. Example:

this is a sentence
this is a second sentence

And I want to show a data table with the most used terms in my Kibana 4.3.1, selecting:

Metric = count
Split rows
Aggregation = terms
Field = input
Order by = metric count
Order descending. Size 5

This is what I'm getting in the table:

this     2
is       2
a        2
sentence 2
second   1

And I want to remove the short words, with less than 3 chars. In this example, "is" and "a".

How can achieve this?

Thanks!

Solution

  • It works adding this Exclude Pattern:

    [a-zA-Z0-9]{0,3}