Converting SQL query to Lucence query grafana

Elastic Stack Elasticsearch
1

Hi,

I can get the data required using Kibana devtool using sql query.

POST _sql?format=txt
{
"query": "SELECT transactionID.keyword, max(responseTime) FROM "test-logs" GROUP BY transactionID.keyword HAVING count(transactionID.keyword)=2 "
}

But I want to display the graphs for transactions with responseTime taken. Can someone help with lucene query for it?

2

Hi,

I have got the solution for it. The trick was Min document count setting 2. See below screen shot for it.

image
image1318×311 28.9 KB

Hope this helps some one facing same issue