# Visualize CSV Data

**URL:** <https://discuss.elastic.co/t/visualize-csv-data/166901>\
**Category:** Kibana\
**Created:** [February 4, 2019, 5:39am UTC](https://discuss.elastic.co/t/visualize-csv-data/166901 "2019-02-04T05:39:37Z")\
**Posts on this page:** 6\
**Page:** 1

<div class="post-metadata">

**Author:** ![andrewjo](https://avatars.discourse-cdn.com/v4/letter/a/b782af/32.png) [@andrewjo](https://discuss.elastic.co/u/andrewjo)\
**Post date:** [February 4, 2019, 5:39am UTC](https://discuss.elastic.co/t/visualize-csv-data/166901/1 "2019-02-04T05:39:37Z")

</div>

Hi Team,

I would like to ask you, how to generate visualize in kibana with this column and value :  
Target Address,Total  
106.1.6.5,209  
114.172.14.110,238  
120.12.28.9,89

This source from CSV Files.  
I try to create some visualization using Pie Chart. This value didn't show with related keys.

Thanks.

---

<div class="post-metadata">

**Author:** ![nickpeihl](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/nickpeihl/32/112622_2.png) [@nickpeihl](https://discuss.elastic.co/u/nickpeihl)\
**Post date:** [February 4, 2019, 8:03pm UTC](https://discuss.elastic.co/t/visualize-csv-data/166901/2 "2019-02-04T20:03:21Z")

</div>

Open the Options tab in the Pie Chart visualization. Make sure the "Show Labels" and "Show Values" checkboxes are checked. This will add series labels and values as percentages.

Alternatively, you can create a Data Table visualization to show the actual counts.

 ![Screenshot_2019-02-04%20%5BFlights%5D%20Airline%20Carrier%20-%20Kibana](https://us1.discourse-cdn.com/elastic/original/3X/5/6/561ae987d3b14b89248cc67c3cf32452dd9d9b7d.png)

 ![Screenshot_2019-02-04%20Kibana(2)](https://us1.discourse-cdn.com/elastic/original/3X/9/1/910b293a8925895f7b455b2af4551557480309bb.png)

---

<div class="post-metadata">

**Author:** ![andrewjo](https://avatars.discourse-cdn.com/v4/letter/a/b782af/32.png) [@andrewjo](https://discuss.elastic.co/u/andrewjo)\
**Post date:** [February 6, 2019, 5:48am UTC](https://discuss.elastic.co/t/visualize-csv-data/166901/3 "2019-02-06T05:48:23Z")

</div>

Hi Nick,

Thanks for your answer.  
Anyway data incoming from csv. And content is summary of field.  
How to visualize with kibana?  
This is screenshoot my kibana and index data.  
 ![1](https://us1.discourse-cdn.com/elastic/original/3X/9/a/9ac5151d599d36c51538ebcd9a653143db0b2d7f.png)

 ![2](https://us1.discourse-cdn.com/elastic/original/3X/9/1/91a1d5604f1e71d34947b8e3a0d1ee3253a579a2.png)  
 ![3](https://us1.discourse-cdn.com/elastic/original/3X/3/f/3f6af298ec0640ae02e125c511f729c7085c86ef.png)  
 ![4](https://us1.discourse-cdn.com/elastic/original/3X/e/3/e346701c7dd306cf73371d1d21819e1e11b52653.png)  
 ![5](https://us1.discourse-cdn.com/elastic/original/3X/d/0/d0858a28af788eae37a5a511f219531d08bded9e.png)  
 ![6](https://us1.discourse-cdn.com/elastic/original/3X/a/b/aba1fd382d1a154295fb0cc3e980cdcdb9442119.png)  
 ![8](https://us1.discourse-cdn.com/elastic/original/3X/e/9/e9633ee783d555ef34aff2ee6732027c58550c73.png)

Values of Field Total should be Target Address Value.  
But it's cannot generate. Can you show me the tips how to generate visualize data with donut chart?

Thanks.

---

<div class="post-metadata">

**Author:** ![nickpeihl](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/nickpeihl/32/112622_2.png) [@nickpeihl](https://discuss.elastic.co/u/nickpeihl)\
**Post date:** [February 6, 2019, 7:09pm UTC](https://discuss.elastic.co/t/visualize-csv-data/166901/4 "2019-02-06T19:09:25Z")

</div>

At this time, pie charts and donut charts only provide percentage values. You may want to use different visualization (column chart, perhaps) if you need other metrics.

---

<div class="post-metadata">

**Author:** ![andrewjo](https://avatars.discourse-cdn.com/v4/letter/a/b782af/32.png) [@andrewjo](https://discuss.elastic.co/u/andrewjo)\
**Post date:** [February 7, 2019, 4:47pm UTC](https://discuss.elastic.co/t/visualize-csv-data/166901/5 "2019-02-07T16:47:37Z")

</div>

Okay,

And what's your chart suggestion?  
Or generate charts using key and values in same single ES document not possible?

Thanks.

---

<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:** [March 7, 2019, 4:47pm UTC](https://discuss.elastic.co/t/visualize-csv-data/166901/6 "2019-03-07T16:47:41Z")

</div>

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