# Make a pie chart based on one field where value is x, y, and z?

**URL:** <https://discuss.elastic.co/t/make-a-pie-chart-based-on-one-field-where-value-is-x-y-and-z/268828>\
**Category:** Kibana\
**Created:** [March 30, 2021, 5:16pm UTC](https://discuss.elastic.co/t/make-a-pie-chart-based-on-one-field-where-value-is-x-y-and-z/268828 "2021-03-30T17:16:20Z")\
**Posts on this page:** 5\
**Page:** 1

<div class="post-metadata">

**Author:** ![riahc3](https://avatars.discourse-cdn.com/v4/letter/r/d6d6ee/32.png) [@riahc3](https://discuss.elastic.co/u/riahc3)\
**Post date:** [March 30, 2021, 5:16pm UTC](https://discuss.elastic.co/t/make-a-pie-chart-based-on-one-field-where-value-is-x-y-and-z/268828/1 "2021-03-30T17:16:20Z")

</div>

Hello

I have a index pattern called my-index-x with entries and a text field that says Results.

What I want to do is in a pie chart for example, make three or more slices: One slices would represent the number that "Success" is found, another "Failure", another "Unknown", and another that would just count any result that is any of those three.

Ive tried to look in Kibana and the documentation itself but either I cant get it to work or IM doing something wrong because I cannot select a field.

I tried Canvas as well but it reads the data as null.

Any guides to get this to work?

Thanks

---

<div class="post-metadata">

**Author:** ![AClerk](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/aclerk/32/55297_2.png) [@AClerk](https://discuss.elastic.co/u/AClerk)\
**Post date:** [March 30, 2021, 10:11pm UTC](https://discuss.elastic.co/t/make-a-pie-chart-based-on-one-field-where-value-is-x-y-and-z/268828/2 "2021-03-30T22:11:41Z")

</div>

You can aggregate by each status/result.  
Counting all statuses in another slice is conceptually wrong and redundant.

---

<div class="post-metadata">

**Author:** ![riahc3](https://avatars.discourse-cdn.com/v4/letter/r/d6d6ee/32.png) [@riahc3](https://discuss.elastic.co/u/riahc3)\
**Post date:** [March 31, 2021, 7:25am UTC](https://discuss.elastic.co/t/make-a-pie-chart-based-on-one-field-where-value-is-x-y-and-z/268828/3 "2021-03-31T07:25:28Z")

</div>

I dont want to add per say.

Just split the pie chart into those results and their value.

I dont see the option though.

---

<div class="post-metadata">

**Author:** ![AClerk](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/aclerk/32/55297_2.png) [@AClerk](https://discuss.elastic.co/u/AClerk)\
**Post date:** [March 31, 2021, 10:06pm UTC](https://discuss.elastic.co/t/make-a-pie-chart-based-on-one-field-where-value-is-x-y-and-z/268828/4 "2021-03-31T22:06:28Z")

</div>

> **[Pie chart | Kibana Guide \[6.8\] | Elastic](https://www.elastic.co/guide/en/kibana/6.8/_pie_chart.html)**

---

<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:** [April 28, 2021, 10:06pm UTC](https://discuss.elastic.co/t/make-a-pie-chart-based-on-one-field-where-value-is-x-y-and-z/268828/5 "2021-04-28T22:06:44Z")

</div>

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