Search request leticene elasticsearch in grafana

Question

I have Grafana 2.6 and Elasticsearch 1.6.2 as a data source

in each of my documents, I have a "status" field, which can have the values ​​"Queued", "Complete"

I would like to calculate the number of documents with the status: Waiting in line

here is 1 document:

{ "_index": "myindex", "_type": "e_sdoc", "_id": "AVHFTlZiGCWSWOI9Qtj4", "_score": 3.2619324, "_source": { "status": "Queued", "update_date": "2015-12-04T00:01:35.589956", "md5": "738b67990f820ba28f3c10bc6c8b6ea3", "sender": "Someone", "type": "0", "last_client_update": "2015-11-18T18:13:32.879085", "uuid": "a80efd11-8ecc-4ef4-afb3-e8cd75d167ad", "name": "Europe", "insert_date": "2015-11-18T18:14:34.302295", "filesize": 10948809532, "is_online": "off", "id1": 77841, "id2": 53550932 }, "fields": { "insert_date": [ 1447870474302 ], "update_date": [ 1449187295589 ], "last_client_update": [ 1447870412879 ] } } 

My question is: Grafana wants the lucene request to go to ES but I have no idea what I should use

Viewed white papers, Grafana issues, or looked at the ES request made by Kibana, but I can't find the current syntax that works: /

Answer 1

time field was a problem. there seems to be no timestamp in my docs

edited my Elasticsearch data source

changed time field name from @timestamp to update_date

I have data points!

(see comments on lucene request)