Elasticsearch sum aggregration

Question

there is documents with category(number), and piece(long) fields. I need some kind of aggregration that group these docs by category and sum all the pieces in it

here how documents looks:

{
"category":"1",
"piece":"10.000"
},
{
"category":"2",
"piece":"15.000"
} ,
{
"category":"2",
"piece":"10.000"
},
{
"category":"3",
"piece":"5.000"
} 
...

The query result must be like:

{
"category":"1",
"total_amount":"10.000"
} 
{
"category":"2",
"total_amount":"25.000"
} 
{
"category":"3",
"total_amount":"5.000"
} 
..

any advice ?

MauricioRoman · Accepted Answer · 2015-10-05 20:39:23Z

1

You want to do a terms aggregation on the categories, from the records above I see that you are sending them as strings, so they will be categorical variables. Then, as a metric, pass on the sum.

This is how it might look:

        "aggs" : {
            "categories" : {
                "terms" : {
                    "field" : "category"
                },
                "aggs" : {
                    "sum_category" : {
                        "sum": { "field": "piece" } 
                    }
                }
            }
        }

answered Oct 5, 2015 at 20:39

MauricioRoman

8222 gold badges9 silver badges15 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

user4005632 Over a year ago

Yes thats exactly true :)

Collectives™ on Stack Overflow

Elasticsearch sum aggregration

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related