# Help to plot CSV

**URL:** <https://discuss.elastic.co/t/help-to-plot-csv/133307>\
**Category:** Kibana\
**Created:** [May 25, 2018, 11:03am UTC](https://discuss.elastic.co/t/help-to-plot-csv/133307 "2018-05-25T11:03:18Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![Luca\_P](https://avatars.discourse-cdn.com/v4/letter/l/bbe5ce/32.png) [@Luca\_P](https://discuss.elastic.co/u/Luca_P)\
**Post date:** [May 25, 2018, 11:03am UTC](https://discuss.elastic.co/t/help-to-plot-csv/133307/1 "2018-05-25T11:03:18Z")

</div>

Hello, I'm rather new to ELK, I need a hint from some experienced Kibana guru here.  
I generate entries in a CSV file that I read with filebeat and send to logstash and ingest into ES. Parsing of fields and ingestion into ES it's ok, I need a hint on how to plot values with Kibana.  
Entries in the CSV are repetitive, let's say I append 4 lines at each time interval, one line per object, like the following:  
timestamp1, object\_A, \<value...\>  
timestamp1, object\_B, \<value...\>  
timestamp1, object\_C, \<value...\>  
timestamp1, object\_D, \<value...\>  
At timestamp2 I add  
timestamp2, object\_A, \<value...\>  
timestamp2, object\_B, \<value...\>  
timestamp2, object\_C, \<value...\>  
timestamp2, object\_D, \<value...\>  
And so forth.

Now, I need to visualize 4 lines, one per object, to represent the values that each object had at each interval, and I'm not quite sure how to do it.  
Any help is much appreciated,  
Regards  
L.

---

<div class="post-metadata">

**Author:** ![Nathan\_Reese](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/nathan_reese/32/84829_2.png) [@Nathan\_Reese](https://discuss.elastic.co/u/Nathan_Reese)\
**Post date:** [May 25, 2018, 3:36pm UTC](https://discuss.elastic.co/t/help-to-plot-csv/133307/2 "2018-05-25T15:36:18Z")

</div>

The first step will be to set up an index pattern in Kibana that points to your ES index. Go to `Management` in the navigation link on the left. Select `Index Patterns` and then click `Create`. Enter the name of your ES index and set the time field.

Once that is done you can start creating graphs by going to the `Visualize` navigation link on the left. Then click `+` button to create a new visualization. Select `Line`. Select the index pattern created above. Now its time to create your graph. Under `buckets` select `Split Series`. Use a terms aggregation on the object name field. Then, under `buckets` select `x-axis`. Use a date histogram aggregation on your time field and select the specified interval. Finally click the `play` button. It is the sideways triangle.

---

<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:** [June 22, 2018, 3:50pm UTC](https://discuss.elastic.co/t/help-to-plot-csv/133307/3 "2018-06-22T15:50:57Z")

</div>

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