Query:
GET data/_search
{
"size": 0,
"query": {
"bool": {
"filter": [
{
"term": {
"type": "datatype1"
}
},
{
"exists": {
"field": "SOME_ID"
}
}
]
}
},
"aggs": {
"group_by_state": {
"terms": {
"script": "doc['COLUMN1'].value/(2048*(doc['COLUMN2'].value+doc['COLUMN3'].value))",
"order": {
"_term": "asc"
},
"size":0
},
"aggs": {
"group_by_field": {
"terms": {
"field": "any_id",
"order": {
"_term": "asc"
},
"size": 0
}
}
}
}
}
}
I want to use histogram so that I can use interval on 'group_by_state' in exponential form (e.g. 2^n (n=..,-3,-2,-1,0,1....)). How to achieve this kind of result by modifying above query?
One more question, is it possible to use log in interval e.g. 1log2?
Please reply ASAP!!