# Hello I want to create pie chart in kibana 7.6 **URL:** \ **Category:** Kibana\ **Created:** [March 6, 2020, 3:03am UTC](https://discuss.elastic.co/t/hello-i-want-to-create-pie-chart-in-kibana-7-6/222398 "2020-03-06T03:03:49Z")\ **Posts on this page:** 11\ **Page:** 1
**Author:** ![Sahana1](https://avatars.discourse-cdn.com/v4/letter/s/47e85d/32.png) [@Sahana1](https://discuss.elastic.co/u/Sahana1)\ **Post date:** [March 6, 2020, 3:03am UTC](https://discuss.elastic.co/t/hello-i-want-to-create-pie-chart-in-kibana-7-6/222398/1 "2020-03-06T03:03:49Z")
1.I have data in my CSV file which is in the attached file format ![image](https://us1.discourse-cdn.com/elastic/original/3X/e/b/eb8dd086accabc9ff04bc289a88ce7167c168e36.png) 2.when i create the pie chart all the it shows as in the below uploaded picture 2 ![2](https://us1.discourse-cdn.com/elastic/original/3X/8/6/86aa734578bde7899ce13cde6904923fa7255cc5.png) 3. actually i want to have my pie chart as shown in the below uploaded picture 3 ![3](https://us1.discourse-cdn.com/elastic/original/3X/2/4/24050c9dc298699a21b6211caec29dd11f9471c8.png) please let me know how to achieve the pie chart as picture 3 with csv file data ---
**Author:** ![Sahana1](https://avatars.discourse-cdn.com/v4/letter/s/47e85d/32.png) [@Sahana1](https://discuss.elastic.co/u/Sahana1)\ **Post date:** [March 6, 2020, 5:02am UTC](https://discuss.elastic.co/t/hello-i-want-to-create-pie-chart-in-kibana-7-6/222398/2 "2020-03-06T05:02:21Z")
Iam new to ELK .Anyone can help me? thanks ---
**Author:** ![warkolm](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/warkolm/32/39224_2.png) [@warkolm](https://discuss.elastic.co/u/warkolm)\ **Post date:** [March 6, 2020, 6:30am UTC](https://discuss.elastic.co/t/hello-i-want-to-create-pie-chart-in-kibana-7-6/222398/3 "2020-03-06T06:30:20Z")
How are you processing the data into Elasticsearch? ---
**Author:** ![Sahana1](https://avatars.discourse-cdn.com/v4/letter/s/47e85d/32.png) [@Sahana1](https://discuss.elastic.co/u/Sahana1)\ **Post date:** [March 6, 2020, 7:38am UTC](https://discuss.elastic.co/t/hello-i-want-to-create-pie-chart-in-kibana-7-6/222398/4 "2020-03-06T07:38:00Z")
File beat -\>log stash-\>elastic search ---
**Author:** ![ErwinEnableU](https://avatars.discourse-cdn.com/v4/letter/e/ce73a5/32.png) [@ErwinEnableU](https://discuss.elastic.co/u/ErwinEnableU)\ **Post date:** [March 6, 2020, 7:50am UTC](https://discuss.elastic.co/t/hello-i-want-to-create-pie-chart-in-kibana-7-6/222398/5 "2020-03-06T07:50:46Z")
Dear Sahana, the reason you have 3 cirkels instead of slices is because you have three buckets. If you parse all data into the same bucket, your pie chart should look like the downloaded picture. ---
**Author:** ![Sahana1](https://avatars.discourse-cdn.com/v4/letter/s/47e85d/32.png) [@Sahana1](https://discuss.elastic.co/u/Sahana1)\ **Post date:** [March 6, 2020, 8:20am UTC](https://discuss.elastic.co/t/hello-i-want-to-create-pie-chart-in-kibana-7-6/222398/6 "2020-03-06T08:20:28Z")
hi thanks , can you show me how to parse data in same bucket ---
**Author:** ![LeeDr](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/leedr/32/9289_2.png) [@LeeDr](https://discuss.elastic.co/u/LeeDr)\ **Post date:** [March 6, 2020, 6:24pm UTC](https://discuss.elastic.co/t/hello-i-want-to-create-pie-chart-in-kibana-7-6/222398/7 "2020-03-06T18:24:53Z")
Kibana can't really make a Pie chart with the data the way it's entered. If if your data has a Date in it, I'm guessing that it changes over time? You could instead use a Line Chart with a Date Histogram like this. In my case I only entered that one row of your csv for that one date so we only see a single dot for those values, but with more data it would show the trend over time. ![image](https://us1.discourse-cdn.com/elastic/original/3X/d/b/db98509d02f2e8f150afdce9a5519da4cd028a70.png) ---
**Author:** ![LeeDr](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/leedr/32/9289_2.png) [@LeeDr](https://discuss.elastic.co/u/LeeDr)\ **Post date:** [March 6, 2020, 8:56pm UTC](https://discuss.elastic.co/t/hello-i-want-to-create-pie-chart-in-kibana-7-6/222398/8 "2020-03-06T20:56:32Z")
To get a Pie Chart, you typically have to split the pie by one field which has different terms in it. Here in Discover you see each doc has a status field and a value field. ![image](https://us1.discourse-cdn.com/elastic/original/3X/6/9/696061db1ea71880fe8edaad1208ea2e081a0e62.png) And then in the pie chart we look at the average value, split by a terms aggregation on the status field. ![image](https://us1.discourse-cdn.com/elastic/original/3X/a/1/a17a3f64d76e631ed47925d2188974bab6480228.png) ---
**Author:** ![Sahana1](https://avatars.discourse-cdn.com/v4/letter/s/47e85d/32.png) [@Sahana1](https://discuss.elastic.co/u/Sahana1)\ **Post date:** [March 9, 2020, 3:30am UTC](https://discuss.elastic.co/t/hello-i-want-to-create-pie-chart-in-kibana-7-6/222398/9 "2020-03-09T03:30:55Z")
Thanks . let me try the above method . ---
**Author:** ![Sahana1](https://avatars.discourse-cdn.com/v4/letter/s/47e85d/32.png) [@Sahana1](https://discuss.elastic.co/u/Sahana1)\ **Post date:** [March 9, 2020, 4:22am UTC](https://discuss.elastic.co/t/hello-i-want-to-create-pie-chart-in-kibana-7-6/222398/10 "2020-03-09T04:22:17Z")
hi LeeDr , i tried as you mentioned in the above pie chart i couldn't get the fields in m y dropdown ![1](https://us1.discourse-cdn.com/elastic/original/3X/9/c/9c07fa3dad5eb34400b1d40d45a84687144698c7.png) ---
**Author:** ![system](https://us1.discourse-cdn.com/elastic/original/3X/1/a/1ac57faf039f6b580b3f104ef42a2a89e41014de.png) [@system](https://discuss.elastic.co/u/system)\ **Post date:** [April 6, 2020, 4:22am UTC](https://discuss.elastic.co/t/hello-i-want-to-create-pie-chart-in-kibana-7-6/222398/11 "2020-04-06T04:22:23Z")
This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.