I want to display chart that displays documents count by date from by Elasticsearch DB.
I am using request to search with following query:
{
"size": 0,
"query": {
"bool": {
"filter": [
{
"term": {
"_index": "my-index"
}
}
],
"must": [
{
"range": {
"created_at": {
"gte": "now-10d/d",
"lte": "now/d"
}
}
}
]
}
},
"aggs": {
"created_histogram": {
"date_histogram": {
"field": "created_at",
"calendar_interval": "day"
}
}
}
}
But retool there is nothing displayed in the retool output:
Seems retool ignores any response filelds except from hits. If I set different size (size=10) - There are documents in the response. But I want to get aggregations.