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

[Noman_Saleem]

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.

[RabBit_BR (andre.coelho)]

Hi @Noman_Saleem !!

Look this:

Kibana dashboard DSL aggregations problem

You can't use aggregations in a filter - filter only operate on a per-document basis. Can you explain which kind of visualization you want to build? Maybe there's another way to achieve your goal.

[Noman_Saleem]

@flash1293 can you help regarding this? Thanks

[warkolm (Mark Walkom)]

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

@Noman_Saleem

I am trying to run the query on query DSL Kibana but its not working

What do you mean by not working?

[Noman_Saleem]

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.