Need help with basic data table

Elastic Stack Kibana
1

I am Super new to ELK and I am trying to create a basic data table visualization just to list some performance metrics. My json looks like this...
{ "MyServer": { "cpu.average": { "2019-05-29 18:00:00+00:00": 1934, "2019-05-29 20:00:00+00:00": 671, "2019-05-29 22:00:00+00:00": 694, "2019-05-30 00:00:00+00:00": 1132, "2019-05-30 02:00:00+00:00": 1169, "2019-05-30 04:00:00+00:00": 634, "2019-05-30 06:00:00+00:00": 56, "2019-05-30 08:00:00+00:00": 55, "2019-05-30 10:00:00+00:00": 64, "2019-05-30 12:00:00+00:00": 144, "2019-05-30 14:00:00+00:00": 57, "2019-05-30 16:00:00+00:00": 57, "2019-05-30 18:00:00+00:00": 408, "2019-05-30 20:00:00+00:00": 1066, "2019-05-30 22:00:00+00:00": 773, "2019-05-31 00:00:00+00:00": 762, "2019-05-31 02:00:00+00:00": 756, "2019-05-31 04:00:00+00:00": 755, "2019-05-31 06:00:00+00:00": 764, "2019-05-31 08:00:00+00:00": 775, "2019-05-31 10:00:00+00:00": 760 }, } }

Naturally this creates items like MyServer.cpu.average.2019-05-29 18:00:00+00:00: 1934. The table I want would just a basic time stamp with the number metric in the second column, but I am having an issue creating it. In the future I would ideally be creating graphs with timestamps....but I am trying to start small and get my feet wet. small :slight_smile:

I partially feel that maybe I need to build my json differently even though this seems to make sense to me.

Really any kind of help or direction would be greatly appreciated.

Thanks!

2

Yes, generally you want each document to reflect a single "thing"- so in this case you would want a document structure like:

{ timestamp: ..., server: "MyServer", cpu.average: 1934 }

3

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