Support of nested queries in Kibana

I have an index with documents like this

{
   "id":1,
   "logs":[
      {
         "who":"max",
         "action":"delete"
      },
      {
         "who":"peter",
         "action":"save"
      }
   ]
},
{
   "id":2,
   "logs":[
      {
         "who":"steve",
         "action":"create"
      },
      {
         "who":"peter",
         "action":"delete"
      }
   ]
}

In Kibana, I would like to visualize the data as a table and bar chat in such a way:

Name    Create    Delete    Save
Steve      1             0              0
Peter      0             1              1
Max        0             1              0

How can I achieve that in Kibana?

Hi @hans_hupe ,

I think there is no easy way to analyse nested fields in Kibana, you can check github issue kibana//58175

There is interesting idea mentioned in this post, I suggest you to check it as you might be able to achive it with Vega.

Best, Dima