# Why I am getting "No results displayed because all values equal 0" for Pie chart?

**URL:** <https://discuss.elastic.co/t/why-i-am-getting-no-results-displayed-because-all-values-equal-0-for-pie-chart/49641>\
**Category:** Kibana\
**Created:** [May 10, 2016, 11:08am UTC](https://discuss.elastic.co/t/why-i-am-getting-no-results-displayed-because-all-values-equal-0-for-pie-chart/49641 "2016-05-10T11:08:37Z")\
**Posts on this page:** 6\
**Page:** 1

<div class="post-metadata">

**Author:** ![vikas\_gopal](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/vikas_gopal/32/47661_2.png) [@vikas\_gopal](https://discuss.elastic.co/u/vikas_gopal)\
**Post date:** [May 10, 2016, 11:08am UTC](https://discuss.elastic.co/t/why-i-am-getting-no-results-displayed-because-all-values-equal-0-for-pie-chart/49641/1 "2016-05-10T11:08:37Z")

</div>

Hi Experts,

I am on kibana 4.1.1 and I have one pie chart visualization, it says **"No results displayed because all values equal 0"**. Not sure if **"No results found"** and **"No results displayed because all values equal 0"** are same , if not what could be the problem ?

 ![](https://us1.discourse-cdn.com/elastic/original/2X/c/c66b2e9ab5145c6aff49325829dbed7a491bd65d.png)

Thanks  
VG

---

<div class="post-metadata">

**Author:** ![BigFunger](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/bigfunger/32/7323_2.png) [@BigFunger](https://discuss.elastic.co/u/BigFunger)\
**Post date:** [May 10, 2016, 6:13pm UTC](https://discuss.elastic.co/t/why-i-am-getting-no-results-displayed-because-all-values-equal-0-for-pie-chart/49641/2 "2016-05-10T18:13:29Z")

</div>

VG,

Can you try to run the queries outside of kibana?

If you expand the spy panel of a visualization and click on the Request  
button, you can see the query that is ultimately sent to elasticsearch.  
You can then use that query in Sense or in an application like Postman  
to query elasticsearch directly. This might reveal some additional  
information about the nature of the data and help determine if the issue is kibana or in the data.

---

<div class="post-metadata">

**Author:** ![vikas\_gopal](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/vikas_gopal/32/47661_2.png) [@vikas\_gopal](https://discuss.elastic.co/u/vikas_gopal)\
**Post date:** [May 11, 2016, 5:19am UTC](https://discuss.elastic.co/t/why-i-am-getting-no-results-displayed-because-all-values-equal-0-for-pie-chart/49641/3 "2016-05-11T05:19:30Z")

</div>

Thanks Jim,

So this is what I got when i run the query outside of kibana . I use sense

Query is

```
GET /_search
{
  "query": {
    "filtered": {
      "query": {
        "query_string": {
          "query": "(src_address:(10.*) OR src_address:(192.168.*) OR src_address:(172.16.*) OR src_address:(172.17.*) OR src_address:(172.18.*)OR src_address:(172.19.*)OR src_address:(172.2*.*) OR src_address:(172.30.*)OR src_address:(172.31.*))",
          "analyze_wildcard": true
        }
      },
      "filter": {
        "bool": {
          "must": [
            {
              "range": {
                "rt": {
                  "gte": 1462857159335,
                  "lte": 1462943559335
                }
              }
            }
          ],
          "must_not": []
        }
      }
    }
  },
  "size": 0,
  "aggs": {
    "2": {
      "terms": {
        "field": "act",
        "size": 10,
        "order": {
          "_count": "desc"
        }
      }
    }
  }
}

```

Sense Result

![](https://us1.discourse-cdn.com/elastic/original/2X/7/74779cfe0acdb62431613b96dd9a57bb86628a5d.png)

I do not see any problem with the result but the strange part is if i fire this query for last 15 min or for today i got **no result found** but for last 24 hours I am getting **"No results displayed because all values equal 0**". Please help me to understand what it the problem ?

---

<div class="post-metadata">

**Author:** ![fred-d](https://avatars.discourse-cdn.com/v4/letter/f/cc9497/32.png) [@fred-d](https://discuss.elastic.co/u/fred-d)\
**Post date:** [May 11, 2016, 9:42am UTC](https://discuss.elastic.co/t/why-i-am-getting-no-results-displayed-because-all-values-equal-0-for-pie-chart/49641/4 "2016-05-11T09:42:34Z")

</div>

"No result found" means no documents matched your query.

"No results displayed because all values equal 0" means that documents were found but the metric calculates 0 for every slice in your pie chart (probably sum of fields that are all 0). This cannot be displayed. If you changed your metric (e.g. to count) this doesn't happen.

---

<div class="post-metadata">

**Author:** ![vikas\_gopal](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/vikas_gopal/32/47661_2.png) [@vikas\_gopal](https://discuss.elastic.co/u/vikas_gopal)\
**Post date:** [May 11, 2016, 12:59pm UTC](https://discuss.elastic.co/t/why-i-am-getting-no-results-displayed-because-all-values-equal-0-for-pie-chart/49641/5 "2016-05-11T12:59:29Z")

</div>

@fred-d So is it kind of bug in pie chart ? because I am using count matrix only also as you suggested I changed the visualization to Data table and it always says **No result found** which is digestible but pie on the other hand is showing **"No results displayed because all values equal 0"** for the same time period.

---

<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:** [July 6, 2017, 1:53pm UTC](https://discuss.elastic.co/t/why-i-am-getting-no-results-displayed-because-all-values-equal-0-for-pie-chart/49641/6 "2017-07-06T13:53:37Z")

</div>