Need help with basic data table

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!

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 }

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