Hello, Lets us assume that i have customers information with city , state. Now i want to Group Customer By State, by City. can anyone help me to form query with the multiple fields? if it is only for state, the query is as shown below GET customerindex/_search { "size": 0, "aggs": { "group_…

This works fine to group by multiple fields(state,city) and calculate sum of the field "total_value", { "size":0, "aggs":{ "group_by_city":{ "terms":{ "field":"city.keyword" }, "aggs":{ "total_amount_city":{ "sum":{ "field":"total_value" } } } }, "group_by_state":{ "terms":{ "field…

Query to group by multiple fields

Elastic Stack Elasticsearch

Jaspreet_Singh (Jaspreet Singh) November 12, 2018, 6:09pm 3

May be a concrete example will help. Can you show what is your requirement with example?

Topic		Replies	Views
Group by multiple fields and aggregate Elasticsearch	1	369	May 19, 2020
Can elasticsearch do GROUP BY multi fields and ORDER BY count? Elasticsearch	3	26797	May 9, 2019
Build relation between elasticsearch aggregators - Nested groupings Elasticsearch	1	341	March 22, 2019
ElasticSearch equivalent query for SQL group by multiple columns Elasticsearch	5	4928	June 16, 2017
Grouping using multiple fields Elasticsearch	1	1731	July 5, 2017

Query to group by multiple fields

Related topics