# Create new pie chart from a data table with different columns

**URL:** <https://discuss.elastic.co/t/create-new-pie-chart-from-a-data-table-with-different-columns/231520>\
**Category:** Kibana\
**Created:** [May 7, 2020, 11:27am UTC](https://discuss.elastic.co/t/create-new-pie-chart-from-a-data-table-with-different-columns/231520 "2020-05-07T11:27:02Z")\
**Posts on this page:** 6\
**Page:** 1

<div class="post-metadata">

**Author:** ![vidhyadhara](https://avatars.discourse-cdn.com/v4/letter/v/c0e974/32.png) [@vidhyadhara](https://discuss.elastic.co/u/vidhyadhara)\
**Post date:** [May 7, 2020, 11:27am UTC](https://discuss.elastic.co/t/create-new-pie-chart-from-a-data-table-with-different-columns/231520/1 "2020-05-07T11:27:02Z")

</div>

Hello,  
I have a data table and i want to plot a pie chart. The screenshot of data table and expected pie chart is attached below. If any body can help me select right aggregations to get the graph it would be helpful. Thanks in advance.

 ![Screenshot (47)](https://us1.discourse-cdn.com/elastic/original/3X/8/f/8f19326a1733c86cbb70bf0fb0723389548610e5.png) ![Screenshot (48)](https://us1.discourse-cdn.com/elastic/original/3X/b/2/b2fb152fedfdda21af6bd12df5689c484a219303.png)

---

<div class="post-metadata">

**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:** [May 7, 2020, 11:41pm UTC](https://discuss.elastic.co/t/create-new-pie-chart-from-a-data-table-with-different-columns/231520/2 "2020-05-07T23:41:06Z")

</div>

Using a terms aggregation on that field, with a sum metric should do it.

---

<div class="post-metadata">

**Author:** ![vidhyadhara](https://avatars.discourse-cdn.com/v4/letter/v/c0e974/32.png) [@vidhyadhara](https://discuss.elastic.co/u/vidhyadhara)\
**Post date:** [May 8, 2020, 4:56am UTC](https://discuss.elastic.co/t/create-new-pie-chart-from-a-data-table-with-different-columns/231520/3 "2020-05-08T04:56:25Z")

</div>

Hi @warkolm,  
Thank you for your reply, but that didn't work for me. There are 4 columns in the table(Total, Unique, Duplicate & Redundant), but i want to plot pie chart for only 3 columns(Unique, Duplicate & Redundant).

---

<div class="post-metadata">

**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:** [May 8, 2020, 5:25am UTC](https://discuss.elastic.co/t/create-new-pie-chart-from-a-data-table-with-different-columns/231520/4 "2020-05-08T05:25:14Z")

</div>

Ahh ok. Then use a filter to exclude the total values 🙂

---

<div class="post-metadata">

**Author:** ![vidhyadhara](https://avatars.discourse-cdn.com/v4/letter/v/c0e974/32.png) [@vidhyadhara](https://discuss.elastic.co/u/vidhyadhara)\
**Post date:** [May 8, 2020, 5:32am UTC](https://discuss.elastic.co/t/create-new-pie-chart-from-a-data-table-with-different-columns/231520/5 "2020-05-08T05:32:01Z")

</div>

Removing 'Total' column is the second task, but i am not able to get pie chart at all for those 3/4 columns. @warkolm

---

<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 5, 2020, 5:32am UTC](https://discuss.elastic.co/t/create-new-pie-chart-from-a-data-table-with-different-columns/231520/6 "2020-06-05T05:32:11Z")

</div>

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