Retrieve count of values for searched string in column using Elastic Search + Kibana

0
votes

Question is similar to this one(How to retrieve unique count of a field using Kibana + Elastic Search )

In my case, data in graph should be count of values from one specific column. For example, I have a column named 'Link' with data:

www.example.com
www.example.com?country=us
www.example.com?country=eng
www.example.com?country=jap
www.example.com?countr=us

So the question is, how to search in column Link only those that have '?country' string and then list those by number.

country=us  | 2
country=eng | 1
country=jap | 1

UPDATE:

Looks like you can't search for a string in string and then to let Kibana transform your data into graph or table on it's own. Check Alains response to solve it differently.

1
elasticsearchlogstashkibana

1 Answers

1
votes

The first step would be to use 'grok' to pull the country value into its own field. Then you can use that on a terms panel in kibana to show you the frequency.