Include Pattern in Kibana visualization

[aeljazouli (Adil)]

Hey everyone,

Je veux calculer le nombre de mots contenus dans un champ "word". Dans cet exemple, il m'affiche 8 mots différents qui sont sur un document d'ID=1.

I'm trying to calculate the number of words on a dictionary that I want to specify in include pattern. But I do not know how to set multiple values for the "word" field.

it works perfectly when I use a single value (see the image below). I put "bonjour" in include.

[jen-huang]

Hi, the Include and Exclude fields here expect regex patterns. So to search multiple words, you can do bonjour|hello|hola, or any other regex pattern such as bon.* which will match bonjour and bonsoir.

[aeljazouli (Adil)]

Hi @jen-huang,

Thanks for your help !!! it did the job. I was able to display a simple table like this one that allows to count the number of mandatory words (That I defined in include pattern).

.

In fact, I'm looking to go further in my visualizations. I do not know that there is a possibility for example to display the words that I defined in include pattern on a visualization (dashboard) and check or uncheck them (or add / remove). To make the task easy to an enduser.

I use this file with Elasticsearch :

{
"meta":{
"ID_FICHIER":127743,
"DATE_APPEL":"2019-06-06 10:22:42",
"SITE":"Casablanca",
"ID_AGENT":2053275,
"PRESTA":"WH",
"TYPE_PRESTATION":"MES",
"ORIGINE":"Appel sortant",
"audio_length":819.657,
"ID_BS":"D0E0628652736"
},
"transcription":[
{
"confidence":0.985514,
"word":"energie"
},
{
"confidence":0.633511,
"word":"madame"
},
{
"confidence":0.533511,
"word":"pleine"
},
{
"confidence":0.767069,
"word":"oui"
},
{
"confidence":0.901756,
"word":"non"
},
{
"confidence":0.901756,
"word":"offre"
},
{
"confidence":0.901756,
"word":"atome"
},
{
"confidence":0.901756,
"word":"direct"
},
{
"confidence":0.901756,
"word":"mechant"
},
{
"confidence":0.901756,
"word":"concurrent"
}
]
}