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

[learningelastic]

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

These two nested aggregations produce the same result, but is one approach better than the other?

I have two scenarios that produce identical aggregation results in the final GET order/_search query. The only difference between the two scenarios is where I choose to declare the type: nested in the mapping and what I specify in the nested.path: in the query. SCENARIO 1 - Declare nested for order_items PUT order POST order/_mapping { "properties": { "order_items": { "type": "nested", "properties": { "product_id": { "type": "long" }, "pro…