CODEWITHSUNDEEP
elasticsearchkibana
AlphaNumerical
AlphaNumerical

Reputation: 45

Kibana Visualization: creating a bar graph with fields in JSON document

New to Kibana visualizations here...

I'm planning on publishing a JSON (once a day) that has populations of list of cities. Following is a sample JSON:

{ 
   "timestamp":"2019-10-10",
   "population_stats":[ 
      { 
         "city":"New York",
         "population":8398748
      },
      { 
         "city":"Los Angeles",
         "population":3976322
      }
   ]
}

I'd like to setup cities in the X axis and population count in Y axis.

I can setup my X axis property (with Field aggregations) however I just can't get the populations to reflect in the Y axis.

Using "count" in the Y axis always gives me 1 -- I guess this is because there's only one document for the given date range.

Is there a proper way to get the correct population count to display on the Y axis?

Upvotes: 0

Views: 1412

Answers (1)

AlphaNumerical
AlphaNumerical

Reputation: 45

Finally managed to figure this out!

Folks are correct about Kibana not being able detecting inner fields, so you basically have to create a JSON for each city (going by my example in the question above). And then from visualizations, you need to select "sum" or "average" aggregation-type. That's all!

Upvotes: 1

Related Questions