# How do I plot CPU load data with respect to datetime using line chart in kibana visualization?

**URL:** <https://discuss.elastic.co/t/how-do-i-plot-cpu-load-data-with-respect-to-datetime-using-line-chart-in-kibana-visualization/211267>\
**Category:** Kibana\
**Created:** [December 10, 2019, 10:01am UTC](https://discuss.elastic.co/t/how-do-i-plot-cpu-load-data-with-respect-to-datetime-using-line-chart-in-kibana-visualization/211267 "2019-12-10T10:01:12Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![Utshab\_Saha](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/utshab_saha/32/58146_2.png) [@Utshab\_Saha](https://discuss.elastic.co/u/Utshab_Saha)\
**Post date:** [December 10, 2019, 10:01am UTC](https://discuss.elastic.co/t/how-do-i-plot-cpu-load-data-with-respect-to-datetime-using-line-chart-in-kibana-visualization/211267/1 "2019-12-10T10:01:12Z")

</div>

I have streamed CPU load data using Firehose to ES and displaying the data in Kibana. Now the problem I am facing is I just want to plot CPU load in Y-axis and datetime in X-axis, but Y-axis asks for aggregation which I don't want in this particular case. So how do I do that?

I have the logs in this format and the are parsed accordingly by **aws-kinesis-agent**

```
10/Dec/2019:09:35:01 0.02 0.01 0.00 2/254 3295

```

And parsed data are showing as bellow in kibana

```
{
 "_index": "cpu-load",
 "_type": "_doc",
 "_id": "49602067745068477890864645725460844388937766040273682434.0",
 "_version": 1,
 "_score": 0,
 "_source": {
  "datetime": "10/Dec/2019:06:41:01",
  "current": "0.07",
  "5min": "0.03",
  "15min": "0.01",
  "procinfo": "2/274",
  "workload": "30143"
 }
}
```

---

<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:** [December 10, 2019, 6:42pm UTC](https://discuss.elastic.co/t/how-do-i-plot-cpu-load-data-with-respect-to-datetime-using-line-chart-in-kibana-visualization/211267/2 "2019-12-10T18:42:10Z")

</div>

To see individual documents, you must use Vega or Canvas to build the queries. These both have a default limit of 10k documents at a time, so if your use case shows fewer than 10k docs then it'll work.

> **[Custom Vega Visualizations in Kibana 6.2](https://www.elastic.co/blog/custom-vega-visualizations-in-kibana)**
>
> A new visualization type in Kibana lets you create custom visualizations using Vega, an open source, JSON-based, declarative language.

---

<div class="post-metadata">

**Author:** ![Utshab\_Saha](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/utshab_saha/32/58146_2.png) [@Utshab\_Saha](https://discuss.elastic.co/u/Utshab_Saha)\
**Post date:** [December 13, 2019, 6:54am UTC](https://discuss.elastic.co/t/how-do-i-plot-cpu-load-data-with-respect-to-datetime-using-line-chart-in-kibana-visualization/211267/3 "2019-12-13T06:54:00Z")

</div>

Thanks @wylie I have made it what I exactly wanted using vega-lite.

 ![image](https://us1.discourse-cdn.com/elastic/original/3X/4/6/4644a71d61ded402117bf39e96c2a4f3f9971154.png)

---

<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:** [January 10, 2020, 6:54am UTC](https://discuss.elastic.co/t/how-do-i-plot-cpu-load-data-with-respect-to-datetime-using-line-chart-in-kibana-visualization/211267/4 "2020-01-10T06:54:04Z")

</div>

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