Building Kibana 5.2 visualization based on the data in the documents (keys as X axis, values as Y) instead of aggregation

Elastic Stack Kibana
1

Here is a sample document in my index:
{"_id":"2018:05:03:19","_source":{"0":9926,"1":53436,"2":81151,"3":56466,"4":29904,...}}.

I am trying to build a bar chart where instead of using aggregation I need to take the keys (0, 1, 2, etc) to use as X axis and corresponding values as Y. All aggregation has already been done in my pipeline.

Has anyone tried something like that? I would really appreciate any suggestions as I am really stuck on this.

Thank you,
Dmitry

2

I think your best bet here is to still aggregate by _id and use something like sum of 0, sum of 1, etc. as your metrics.

3

Hi Lukas. Thank you for responding. I was trying to use Terms aggregation but I cannot select _id as one of the fields. As you can see from my _id format they are date:hour based. Do you have any suggestions?

4

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