# Need help with basic data table

**URL:** <https://discuss.elastic.co/t/need-help-with-basic-data-table/195538>\
**Category:** Kibana\
**Created:** [August 16, 2019, 5:25pm UTC](https://discuss.elastic.co/t/need-help-with-basic-data-table/195538 "2019-08-16T17:25:28Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![vNoob](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/vnoob/32/61863_2.png) [@vNoob](https://discuss.elastic.co/u/vNoob)\
**Post date:** [August 16, 2019, 5:25pm UTC](https://discuss.elastic.co/t/need-help-with-basic-data-table/195538/1 "2019-08-16T17:25:28Z")

</div>

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 🙂

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!

---

<div class="post-metadata">

**Author:** ![wylie](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/wylie/32/81794_2.png) [@wylie](https://discuss.elastic.co/u/wylie)\
**Post date:** [August 16, 2019, 5:38pm UTC](https://discuss.elastic.co/t/need-help-with-basic-data-table/195538/2 "2019-08-16T17:38:52Z")

</div>

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 }`

---

<div class="post-metadata">

**Author:** ![system](https://us1.discourse-cdn.com/elastic/original/3X/1/a/1ac57faf039f6b580b3f104ef42a2a89e41014de.png) [@system](https://discuss.elastic.co/u/system)\
**Post date:** [September 13, 2019, 5:39pm UTC](https://discuss.elastic.co/t/need-help-with-basic-data-table/195538/3 "2019-09-13T17:39:00Z")

</div>

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