Elastic search queries working for _search endpoint are not working for query DSL filter in Kibana

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.

Hi @Noman_Saleem !!

Look this:

1 Like

@flash1293 can you help regarding this? Thanks

Welcome to our community! :smiley: Please don't ping people that aren't already part of your topic.

What do you mean by not working?

Thanks, and as I have seen him answering similar sort of question, and after not getting any response for few days, I pinged him.

My only questions is that, can we run Elasticsearch raw queries(that include aggregations, group by, the one given in the question above) in the kibana to create interactive visualizations(plotly based)? Though non-interactive visualizations can be created in the kibana canvas using the raw Elasticsearch queries.