无法从Grafana 2.x中的Elasticsearch Lucene查询中绘制图表

Question

我正在将grafana与elasticsearchas数据源一起使用。在我的每个文档上，我都有一个字段" ID"one_answers" LastModifiedDate"。我想用ID的count显示桌子的最后修改日期。

这是我的文档：

{
        "_index": "global_search",
        "_type": "News_Item",
        "_id": "48",
        "_score": 1,
        "_source": {
          "id": "48",
          "dueDate": 1478802600000,
          "lastModifiedDate": 1478802600000,
          "whenCreatedDate": 1477506600000,
          "ownerEmail": "[e-mail]",
          "owner": {
            "firstname": "ABC",
            "lastname": "Kumar",
            "email": "[e-mail]"
          },
          "subject": "USA','According to NBCDFW.com, an explosion at a silicon plant ",
          "status": "NEW",
          "updatedby": "ABC Kumar",
          "content": "Text data"
        }
      },
      {
        "_index": "global_search",
        "_type": "News_Item",
        "_id": "26",
        "_score": 1,
        "_source": {
          "id": "26",
          "dueDate": 1477679400000,
          "lastModifiedDate": 1477679400000,
          "whenCreatedDate": 1477506600000,
          "researchTitle": "Flash Floods Hit Parts of Southern France",
          "ownerEmail": "[e-mail]",
          "owner": {
            "firstname": "XYZ",
            "lastname": "Kumar",
            "email": "[e-mail]"
          },
          "subject": "Flash Floods Hit Parts of Southern France",
          "status": "MONITORING",
          "updatedby": "XYZ",
          "content": "Text2 data"
        }
      }

问题：如何根据日期使用ID的计数绘制表？绘制表格的确切Lucene查询是什么？

Answer 1

您可以使用以下查询参数获取它：

Metric:
  Count
Group by:
  type: Date Histogram
  field: lastModifiedDate

查询字段可以留空。