Hi, I am trying to run the query on query DSL Kibana but its not working but the same query is working for the _search endpoint. Here is the query.
{
"size": 0,
"query": {
"range": {
"timestamp": {
"gte": "2021-03-30T00:00:00.000Z",
"lte": "2021-12-06T00:00:00.000Z",
"time_zone": "Z",
"boost": 1.0
}
}
},
"_source": false,
"aggregations": {
"groupby": {
"composite": {
"size": 10,
"sources": [
{
"e88a97fe": {
"terms": {
"field": "timestamp",
"missing_bucket": true,
"order": "asc"
}
}
}
]
}
}
}
}
Secondly can we create interactive graphs(plotly graphs) in the Kibana canvas like we can create in the lens visualizations dashboard?
Thirdly can we directly use queries in the SQL syntax for creating the lens visualizations?
Thanks.