For each value from a terms aggregation, get the count of documents that abide to the condition of lte to that value.
{
...
"aggs": {
"all_values": {
"terms": {
"field": "characteristics.values.value" //for each of these values
}
}
},
"nested": {
"path": "characteristics.values"
}
}
Note: The characteristics.values.value is a keyword, so I will somehow have to use a script or some other approach to convert it to numeric/interger.
I cannot change it from keyword as the code generating the query is generic for other queries as well.
With scipt, it should be something like this?:
"source": "Float.parseFloat(doc['characteristics.values.value'].value).value"