How to group by month in Elastic search
0 0 I am using elastic search version 6.0.0 for group by month, I am using date histogram aggregation. example which I've tried : "from":0, "size":2000, "_source": "includes":[ "cost", "date" ], "excludes":[ ], "aggregations": "date_hist_agg": "date_histogram": "field":"date", "interval":"month", "format":"M", "order": "_key":"asc" , "min_doc_count":1 , "aggregations": "cost": "sum": "field":"cost" and as a result i got 1(Jan/January) multiple times. As I have data of January-2016 ,January-2017 , January-2018 so will return 3 times January. but i Want January only once which contains the sum of All years of January. elasticsearch elasticsearch-5 elasticsearch-aggregation elasticsearch-6 ...