How to count number of fileds on nested object with Elasticsearch and kibana

Hi there,
I want to count number of fields on a nested object that matchs a query in order to visualize them on Kibana.

{
   "meta":{
      "ID_FICHIER":127745,
      "DATE_APPEL":"2018-10-15'T'17:17:45",
      "SITE":"Casablanca",
      "ID_AGENT":2053280
   },
   "transcription":[
      {
         "confidence":0.985514,
         "word":"madame"
      },
      {
         "confidence":0.633511,
         "word":"non"
      },
      {
         "confidence":0.533511,
         "word":"bon"
      },
      {
         "confidence":0.767069,
         "word":"belle"
      },
      {
         "confidence":0.901756,
         "word":"pizza"
      }
   ]
}

For example : How many words have "pizza" value ?

This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.