# How to ignore empty values on Bar Chart (displaying percentage)
**URL:** https://discuss.elastic.co/t/how-to-ignore-empty-values-on-bar-chart-displaying-percentage/146764
**Category:** Kibana
**Created:** [August 30, 2018, 6:09pm UTC](https://discuss.elastic.co/t/how-to-ignore-empty-values-on-bar-chart-displaying-percentage/146764 "2018-08-30T18:09:29Z")
**Posts on this page:** 9
**Page:** 1
### Author:  [@obaid](https://discuss.elastic.co/u/obaid)
#### Post date: [August 30, 2018, 6:09pm UTC](https://discuss.elastic.co/t/how-to-ignore-empty-values-on-bar-chart-displaying-percentage/146764/1 "2018-08-30T18:09:29Z")
Hi,
Is there a way to ignore empty values, such that Kibana don't display the Bars (highlighted) for empty values in the screen shot below?
Actually, if on the left I select 'normal' instead of 'percentage', it gives me the desired result i.e plotting only a single bar where some of the values are 'Y', while ignoring the empty values altogether. However as I select 'percentage' it shows me bars for values that dont exists (I think it just divides the bar evenly among all expected fields).
I will appreciate any help in addressing this issue
Thanks
---
### Author:  [@bhavyarm](https://discuss.elastic.co/u/bhavyarm)
#### Post date: [August 30, 2018, 6:59pm UTC](https://discuss.elastic.co/t/how-to-ignore-empty-values-on-bar-chart-displaying-percentage/146764/2 "2018-08-30T18:59:23Z")
Hi,
You can change the min\_doc\_count of the field to greater than zero: [https://www.elastic.co/guide/en/elasticsearch/reference/current/search-aggregations-bucket-terms-aggregation.html](https://www.elastic.co/guide/en/elasticsearch/reference/current/search-aggregations-bucket-terms-aggregation.html) in JSON input under advanced in visualization editor.
That should make sure that Kibana will ignore the empty values.
Thanks,
Bhavya
---
### Author:  [@obaid](https://discuss.elastic.co/u/obaid)
#### Post date: [August 30, 2018, 7:12pm UTC](https://discuss.elastic.co/t/how-to-ignore-empty-values-on-bar-chart-displaying-percentage/146764/3 "2018-08-30T19:12:11Z")
Should I put the following similar JSON script in Advances Json input? Actually I tried and it dosent show any difference, would you also share an example Json ?
```
{
"aggs" : {
"tags" : {
"terms" : {
"field" : "tags",
"min_doc_count": 10
}
}
}
}
```
---
### Author:  [@bhavyarm](https://discuss.elastic.co/u/bhavyarm)
#### Post date: [August 30, 2018, 7:31pm UTC](https://discuss.elastic.co/t/how-to-ignore-empty-values-on-bar-chart-displaying-percentage/146764/4 "2018-08-30T19:31:48Z")
Hi,
Here you go: I ingested logs data from load data into Kibana tutorial( [https://www.elastic.co/guide/en/kibana/current/tutorial-load-dataset.html](https://www.elastic.co/guide/en/kibana/current/tutorial-load-dataset.html)), created an area chart on count on y-axis and terms on x-axis and gave this value in advanced json: {"min\_doc\_count":1437}. This basically made the area chart ignore document documents with machine.os as osx.
Without the min\_doc\_count:
Hope this helps.
Thanks,
Bhavya
---
### Author:  [@obaid](https://discuss.elastic.co/u/obaid)
#### Post date: [August 30, 2018, 7:36pm UTC](https://discuss.elastic.co/t/how-to-ignore-empty-values-on-bar-chart-displaying-percentage/146764/5 "2018-08-30T19:36:42Z")
Thanks, but I am getting following error, is it supported for 'Filters' ? I am using Filters, where each field has to be considered if its value is 'Y':
```
Visualize: [parsing_exception] Unknown key for a VALUE_NUMBER in [3]: [min_doc_count]., with { line=1 & col=1437 }
Less Info
OK
296s
Error: [parsing_exception] Unknown key for a VALUE_NUMBER in [3]: [min_doc_count]., with { line=1 & col=1437 }
at respond (https://gkibana.clouddqt.capitalone.com/bundles/kibana.bundle.js?v=16588:109:161556)
at checkRespForFailure (https://gkibana.clouddqt.capitalone.com/bundles/kibana.bundle.js?v=16588:109:160796)
at https://gkibana.clouddqt.capitalone.com/bundles/kibana.bundle.js?v=16588:103:301134
at processQueue (https://gkibana.clouddqt.capitalone.com/bundles/vendors.bundle.js?v=16588:35:132456)
at https://gkibana.clouddqt.capitalone.com/bundles/vendors.bundle.js?v=16588:35:133349
at Scope.$digest (https://gkibana.clouddqt.capitalone.com/bundles/vendors.bundle.js?v=16588:35:144239)
at Scope.$apply (https://gkibana.clouddqt.capitalone.com/bundles/vendors.bundle.js?v=16588:35:147018)
at done (https://gkibana.clouddqt.capitalone.com/bundles/vendors.bundle.js?v=16588:35:100026)
at completeRequest (https://gkibana.clouddqt.capitalone.com/bundles/vendors.bundle.js?v=16588:35:104697)
at XMLHttpRequest.xhr.onload (https://gkibana.clouddqt.capitalone.com/bundles/vendors.bundle.js?v=16588:35:105435
```
---
### Author:  [@bhavyarm](https://discuss.elastic.co/u/bhavyarm)
#### Post date: [August 30, 2018, 7:39pm UTC](https://discuss.elastic.co/t/how-to-ignore-empty-values-on-bar-chart-displaying-percentage/146764/6 "2018-08-30T19:39:42Z")
ah I don't think so. I am tagging our viz team to see if they have an answer.
@timroes/@ppisljar
Thanks,
Bhavya
---
### Author:  [@timroes](https://discuss.elastic.co/u/timroes)
#### Post date: [August 31, 2018, 9:06am UTC](https://discuss.elastic.co/t/how-to-ignore-empty-values-on-bar-chart-displaying-percentage/146764/7 "2018-08-31T09:06:17Z")
Hi,
`min_doc_count` does not exist on the Filters aggregation and thus cannot be used in this place. I think you are running an older version of Kibana? The wrong behavior of 0 in percentage charts has been fixed via [https://github.com/elastic/kibana/pull/15765](https://github.com/elastic/kibana/pull/15765) for 6.3.0. Upgrading to 6.3 (or better 6.4) will solve that issue.
Cheers,
Tim
---
### Author:  [@obaid](https://discuss.elastic.co/u/obaid)
#### Post date: [August 31, 2018, 1:45pm UTC](https://discuss.elastic.co/t/how-to-ignore-empty-values-on-bar-chart-displaying-percentage/146764/8 "2018-08-31T13:45:42Z")
Thanks for the clarification, it make sense now.
---
### Author:  [@system](https://discuss.elastic.co/u/system)
#### Post date: [September 28, 2018, 1:46pm UTC](https://discuss.elastic.co/t/how-to-ignore-empty-values-on-bar-chart-displaying-percentage/146764/10 "2018-09-28T13:46:38Z")
This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.