I'm trying to get the sum of a field in a parent node while aggregating on a field of a child node. For example, this is what I've setup: PUT order POST order/_mapping { "properties": { "order_items": { "type": "nested", "properties": { "product_id": { "type": …

I did some changes. Look: PUT order POST order/_mapping { "properties": { "order_items": { "type": "nested", "properties": { "product_id": { "type": "long" }, "product": { "properties": { "manufacturer": { "pro…

Discuss the Elastic Stack

Sum of a field in a parent node and grouping by a field in a child node

Elastic Stack Elasticsearch

learningelastic (learningelastic) February 8, 2023, 1:46pm 5

Your answer worked! And I have a related question on this page here in case you know the answer. Thank you in advance!

1 Like

Topic		Replies	Views
Parent aggregation based on child terms Elasticsearch	1	695	June 20, 2017
Sum aggregation on nested query Elasticsearch	2	3293	October 18, 2018
Group by & sum field Elasticsearch	6	18576	July 5, 2017
Terms aggregation on a nested field for calculating stats based on a parent-field Elasticsearch	2	1176	July 20, 2020
Order by child-parent atributes on nested documents Elasticsearch	1	405	July 5, 2017

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.

Sum of a field in a parent node and grouping by a field in a child node

Related topics