var toto = { "query": { "bool": { "must": [{ "term": { "eventId": "afterWorkflowTaskEnded" } }, { "term": { "extended.modelName": "TravelExpenseValidation" } }, { "term": { "extended.taskName": "wf.travelExpenses.create" } }, { "range": { "eventDate": { "gte": "2015-11-03", "lte": "2015-11-10" } } }] } }, "aggs": { "by": { "terms": { "field": "extended.taskActor" }, "aggs": { "by": { "date_histogram": { "field": "eventDate", "interval": "day", "format": "yyyy-MM-dd", "min_doc_count": 0, "extended_bounds": { "min": "2015-11-03", "max": "2015-11-10" } }, "aggs": { "metrics": { "sum": { "field": "extended.workflowVariables.amount" } } } } } } } };