Count records form different fields on kibana

Elastic Stack Kibana
1

Hi guys! I'm very new on kibana, I need your help I'm trying to do a pie chart with the count of keywords of different fields:
I have like 7 fields that I post like a Json. Like this:

{
        "England": {
             "London":{
                        "isEuropean": "true"
                      }
             "Manchester":{
                          "isEuropean":"true"
                          }
                    }
          "Spain": 
                    {
             "Madrid":{
                         "isEuropean":"true"
                      }
             "Barcelona":{
                           "isEuropean":"true"
                          }
                    }
"Usa": 
                    {
             "New York":{
                         "isEuropean":"false"
                      }
             "Chicago":{
                           "isEuropean":"false"
                          }
                    }
    }

So I want to count how many cities are European and how many are not.
I don't know how can I count this field and displayed the percentage. Please help me.
Regards

2

Welcome to our community! :smiley: We aren't all guys though :slight_smile:

Can you try "*.*.isEuropean": "false" in a query and see if that works?
I'm not 100% sure it will, but it's worth a try.

3

Thank you friend! I tried adding filter field but don't accept me the filter, Where I have to set this value?

4

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