I'm searching for a way to accomplish the following:
I've got a date histogram interval that is by "day" and i'd like to add the parent_size into a sum only once even if the related associations.c occurs many times within that date histogram interval. Ideally I'd to be able to perform this query with any date histogram interval using the same "sum parent_size once for each unique associations.c per day" logic.
Below is an example document in the index I'm querying against:
{
"associations": {
"a": [
"2514519s-f379-11e3-ae2b-3176bd53680f"
],
"b": [
"5e8a07af-d2d3-4a1c-ba43-07f5cfc0eb8d"
],
"c": [
"6bda18ag-f379-11e3-ae2b-3176bd53680f"
]
},
"parent_size": 110,
"id": "d5fe6216-7eb7-4d81-b3b2-eef28850b80d",
"created_at": "2016-05-23T23:51:17.661Z"
}