Kibana displays boolean data true as 1 and false as 0 while visualizing

[aviral_srivastava]

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

[BigFunger (Jim Unger)]

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

[aviral_srivastava]

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

[3ygun]

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
• Or add a string field to the Boolean variable mapping in Elasticsearch within the dynamic template (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