# KIbana Pie Chart Duplicates

**URL:** https://discuss.elastic.co/t/kibana-pie-chart-duplicates/79261
**Category:** Kibana
**Created:** [March 20, 2017, 1:43pm UTC](https://discuss.elastic.co/t/kibana-pie-chart-duplicates/79261 "2017-03-20T13:43:20Z")
**Posts on this page:** 7
**Page:** 1

<div class="post-metadata">

### Author: ![marathon88](https://avatars.discourse-cdn.com/v4/letter/m/e5b9ba/32.png) [@marathon88](https://discuss.elastic.co/u/marathon88)
#### Post date: [March 20, 2017, 1:43pm UTC](https://discuss.elastic.co/t/kibana-pie-chart-duplicates/79261/1 "2017-03-20T13:43:21Z")

</div>

Using a Pie Chart with a metric of Count and Terms under the Split Slices Bucket. The same term is listed on two slices. The underlying data is in elastic search and was loaded from data that was originally in SQL. The term count in SQL is 57184 for the term HARD INOP.. However the pie chart has HARD INOP listed twice. Once with a count of 54,802 and once with a count of 2,382.

---

<div class="post-metadata">

### Author: ![lukas](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/lukas/32/6812_2.png) [@lukas](https://discuss.elastic.co/u/lukas)
#### Post date: [March 21, 2017, 8:23pm UTC](https://discuss.elastic.co/t/kibana-pie-chart-duplicates/79261/2 "2017-03-21T20:23:17Z")

</div>

Could you provide a screenshot?

---

<div class="post-metadata">

### Author: ![marathon88](https://avatars.discourse-cdn.com/v4/letter/m/e5b9ba/32.png) [@marathon88](https://discuss.elastic.co/u/marathon88)
#### Post date: [March 22, 2017, 12:50pm UTC](https://discuss.elastic.co/t/kibana-pie-chart-duplicates/79261/3 "2017-03-22T12:50:23Z")

</div>

![](https://us1.discourse-cdn.com/elastic/original/3X/0/0/00a208254f82e3985ace9f772b7b232113127873.png)

---

<div class="post-metadata">

### Author: ![marathon88](https://avatars.discourse-cdn.com/v4/letter/m/e5b9ba/32.png) [@marathon88](https://discuss.elastic.co/u/marathon88)
#### Post date: [March 22, 2017, 12:54pm UTC](https://discuss.elastic.co/t/kibana-pie-chart-duplicates/79261/4 "2017-03-22T12:54:48Z")

</div>

![](https://us1.discourse-cdn.com/elastic/original/3X/3/0/30e422fad8662febefc237319c8b90256a76455d.png)

---

<div class="post-metadata">

### Author: ![marathon88](https://avatars.discourse-cdn.com/v4/letter/m/e5b9ba/32.png) [@marathon88](https://discuss.elastic.co/u/marathon88)
#### Post date: [March 22, 2017, 12:55pm UTC](https://discuss.elastic.co/t/kibana-pie-chart-duplicates/79261/5 "2017-03-22T12:55:03Z")

</div>

GET /hadoopalarmevents-v1/\_search  
{ "query" : {  
"term" : {  
"ReportCategory" :  
"HARD INOP"  
}  
}  
}  
{  
"took": 2,  
"timed\_out": false,  
"\_shards": {  
"total": 5,  
"successful": 5,  
"failed": 0  
},  
"hits": {  
"total": 92662,  
"max\_score": 1.6108929,  
"hits": [  
{

---

<div class="post-metadata">

### Author: ![marathon88](https://avatars.discourse-cdn.com/v4/letter/m/e5b9ba/32.png) [@marathon88](https://discuss.elastic.co/u/marathon88)
#### Post date: [March 22, 2017, 1:01pm UTC](https://discuss.elastic.co/t/kibana-pie-chart-duplicates/79261/6 "2017-03-22T13:01:53Z")

</div>

Believe I found the answer just now.. Spaces in front of one of the values

GET /hadoopalarmevents-v1/alarms/\_search  
{  
"size": 0,  
"aggs": {  
"distinct\_categories": {  
"terms": {  
"field": "ReportCategory",  
"size": 1000  
}  
}  
}  
}

{  
"took": 11,  
"timed\_out": false,  
"\_shards": {  
"total": 5,  
"successful": 5,  
"failed": 0  
},  
"hits": {  
"total": 461172,  
"max\_score": 0,  
"hits": []  
},  
"aggregations": {  
"distinct\_categories": {  
"doc\_count\_error\_upper\_bound": 0,  
"sum\_other\_doc\_count": 0,  
"buckets": [  
{  
"key": "SOFT INOP",  
"doc\_count": 183893  
},  
{  
"key": "WARNING",  
"doc\_count": 151290  
},  
{  
"key": "HARD INOP",  
"doc\_count": 92662  
},  
{  
"key": "ARRHYTHMIA",  
"doc\_count": 24153  
},  
{  
"key": "CRITICAL",  
"doc\_count": 8476  
},  
{  
"key": "HARD INOP ",  
"doc\_count": 606  
},  
{  
"key": "UNKNOWN",  
"doc\_count": 92  
}  
]  
}  
}  
}

---

<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 19, 2017, 1:02pm UTC](https://discuss.elastic.co/t/kibana-pie-chart-duplicates/79261/7 "2017-04-19T13:02:06Z")

</div>

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