I just want to exactly this query select a ,count(a) from table group by b ; just want to show a result that a, count a but distinct duplicate b. It can be bar or anything plz let me know how can i distinct column b with showing result a.

How can I make visualization with GROUP BY

tbragin (Tanya Bragin) March 9, 2016, 5:20am 2

Most likely you are looking for the Terms aggregation in ES/Kibana terminology. In screenshot below, a=response, b=city_name

Kibana Visualize - How to aggregate data with two string field values?

Elasticsearch is a trademark of Elasticsearch BV, registered in the U.S. and in other countries
Trademarks
Terms
Privacy
Brand
Code of Conduct

Apache, Apache Lucene, Apache Hadoop, Hadoop, HDFS and the yellow elephant logo are trademarks of the Apache Software Foundation in the United States and/or other countries.