Converting SQL query to Lucence query grafana


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?


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

Hope this helps some one facing same issue

This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.