弹性搜索5中的复杂搜索查询

Question

我在弹性搜索数据库中有跟踪记录。

  {
    "frd": "2017-06-30",
    "tim": "2017-01-19T11:02:21.847",
    "tpr": 2276.5
  },
  {
    "frd": "2017-06-29",
    "tim": "2017-01-19T11:02:21.847",
    "tpr": 2408.5
  },
  {
    "frd": "2017-06-28",
    "tim": "2017-01-20T12:01:08.358",
    "tpr": 2408.5
  },
  {
    "frd": "2017-06-30",
    "tim": "2017-01-20T12:01:08.358",
    "tpr": 2276.5
  },
  {
    "frd": "2017-06-30",
    "tim": "2017-01-20T17:35:17.495",
    "tpr": 2408.5
  },
  {
    "frd": "2017-06-30",
    "tim": "2017-01-19T10:04:44.586",
    "tpr": 2276.5
  },
  {
    "frd": "2017-06-30",
    "tim": "2017-01-19T10:15:46.051",
    "tpr": 2276.5
  }

弹性版本是5。我将创建一个多系列线图从上面的数据集，所以我想得到一个新的json从上面的数据如下。

[
  {
    "tim": "2017-01-19T11:02:21.847",
    "2017-06-28": null,
    "2017-06-29": 2408.5,
    "2017-06-30": 2276.5
  },
  {
    "tim": "2017-01-20T12:01:08.358",
    "2017-06-28": 2408.5,
    "2017-06-29": null,
    "2017-06-30": 2276.5
  },
  {
    "tim": "2017-01-20T17:35:17.495",
    "2017-06-28": null,
    "2017-06-29": null,
    "2017-06-30": 2408.5
  },
  {
    "tim": "2017-01-19T10:04:44.586",
    "2017-06-28": null,
    "2017-06-29": null,
    "2017-06-30": 2276.5
  },
  {
    "tim": "2017-01-19T10:15:46.051",
    "2017-06-28": null,
    "2017-06-29": null,
    "2017-06-30": 2276.5
  }
]

X轴变成值。Y轴为tpr。行应该由frd分组。

是否有方法从弹性数据中获得上述图表数据集，并进行弹性查询？

谢谢

Answer 1

对于可视化，您可以直接使用Kibana (v5)。在那里，您可以通过选择想要的任何字段来直接绘制线图。

下面是指向Kibana 5.1用户指南的链接