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?

Topic		Replies	Views
Can't show distinct value in canvas Kibana canvas	4	503	November 22, 2023
I am trying to perform aggregation on top aggregations results in kibana visualization tab. Can anyone please help me how to achieve this Kibana	2	171	April 26, 2022
How to calculate ,count of distinct column in kibana canvas Kibana canvas	3	7113	July 10, 2019
Group by count? Kibana	2	1713	July 6, 2017
Visualizing with Kibana Kibana	4	491	March 1, 2017