How to sum fieds of collapsed results?

Elastic Stack Elasticsearch
1

Hi,
I need to do a sum aggregation on a collapsed result. I know that collapse does not effect on aggregation but there are other ways?

For example:

  • Field1 = A, Field2 = 50, Order = 1
  • Field1 = A, Field2 = 30, Order = 2
  • Field1 = B, Field2 = 20, Order = 1

My query is ordered by "Order" and collapsed on "Field1", then I want to sum "Field2" of the collapsed result to obtain, in this case, the value 70.

Is it possible?

2

This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.