# Kibana displays boolean data true as 1 and false as 0 while visualizing
**URL:** https://discuss.elastic.co/t/kibana-displays-boolean-data-true-as-1-and-false-as-0-while-visualizing/53746
**Category:** Kibana
**Created:** [June 23, 2016, 8:15am UTC](https://discuss.elastic.co/t/kibana-displays-boolean-data-true-as-1-and-false-as-0-while-visualizing/53746 "2016-06-23T08:15:08Z")
**Posts on this page:** 5
**Page:** 1
### Author:  [@aviral\_srivastava](https://discuss.elastic.co/u/aviral_srivastava)
#### Post date: [June 23, 2016, 8:15am UTC](https://discuss.elastic.co/t/kibana-displays-boolean-data-true-as-1-and-false-as-0-while-visualizing/53746/1 "2016-06-23T08:15:08Z")
Dear Users,
I have an index named as fc. It has two types db and iis.
Under type iis, I have one field status[boolean datatype] whose value is true/false.
While Visualizing data in kibana it displays true as 1 and false as 0.
Is there any way to display the value as it is , i.e. true or false
---
### Author:  [@BigFunger](https://discuss.elastic.co/u/BigFunger)
#### Post date: [June 23, 2016, 4:41pm UTC](https://discuss.elastic.co/t/kibana-displays-boolean-data-true-as-1-and-false-as-0-while-visualizing/53746/2 "2016-06-23T16:41:47Z")
What does kibana say the type of that field is?
I just created a simple index/index pattern
and my boolean values show up as TRUE and FALSE
---
### Author:  [@aviral\_srivastava](https://discuss.elastic.co/u/aviral_srivastava)
#### Post date: [June 24, 2016, 5:47am UTC](https://discuss.elastic.co/t/kibana-displays-boolean-data-true-as-1-and-false-as-0-while-visualizing/53746/3 "2016-06-24T05:47:09Z")
Dear Jim,
You are absolutely right. Thanks for your time.
But
When we create for example pie chart and use terms aggregations and select Boolean field,
you will see that the tooltip and the legend mentions 1 instead of true and 0 instead of false as value.
I am currently using elasticsearch2.1.0 and kibana4.3.0
---
### Author:  [@3ygun](https://discuss.elastic.co/u/3ygun)
#### Post date: [August 1, 2016, 5:51pm UTC](https://discuss.elastic.co/t/kibana-displays-boolean-data-true-as-1-and-false-as-0-while-visualizing/53746/4 "2016-08-01T17:51:19Z")
For those trying to get around this issue you can:
- Create a boolean field formatter as described here: [Blog Post on Kibana 4.X field formatter](https://www.timroes.de/2016/02/17/writing-kibana-4-plugins-field-formatters/)
- Or add a string field to the Boolean variable mapping in Elasticsearch within the [dynamic template](https://www.elastic.co/guide/en/elasticsearch/reference/current/dynamic-mapping.html) (NOTE: This assumes you can fix the problem on data input)
> ```
> {
> "template" : "boolean",
> "settings" : {
> "index.refresh_interval" : "5s"
> },
> "mappings" : {
> "_default_" : {
> "_all" : {"enabled" : true, "omit_norms" : true},
> "dynamic_templates" : [ {
> "bool_fields" : {
> "match_mapping_type": "boolean",
> "mapping": {
> "fields" : {
> "raw" : {"type": "string", "index" : "not_analyzed", "ignore_above" : 5}
> }
> }
> }
> } ]
> }
> }
> }
>
> ```
[Open issue](https://github.com/elastic/kibana/issues/7898)
---
### Author:  [@system](https://discuss.elastic.co/u/system)
#### Post date: [July 6, 2017, 1:42pm UTC](https://discuss.elastic.co/t/kibana-displays-boolean-data-true-as-1-and-false-as-0-while-visualizing/53746/5 "2017-07-06T13:42:46Z")