# V 8.5.0 update - boolean field not working in donut lens anymore

**URL:** <https://discuss.elastic.co/t/v-8-5-0-update-boolean-field-not-working-in-donut-lens-anymore/318949>\
**Category:** Kibana\
**Created:** [November 15, 2022, 11:09am UTC](https://discuss.elastic.co/t/v-8-5-0-update-boolean-field-not-working-in-donut-lens-anymore/318949 "2022-11-15T11:09:19Z")\
**Posts on this page:** 13\
**Page:** 1

<div class="post-metadata">

**Author:** ![mayer](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/mayer/32/42164_2.png) [@mayer](https://discuss.elastic.co/u/mayer)\
**Post date:** [November 15, 2022, 11:09am UTC](https://discuss.elastic.co/t/v-8-5-0-update-boolean-field-not-working-in-donut-lens-anymore/318949/1 "2022-11-15T11:09:19Z")

</div>

Dear All,

recently I updated to version 8.5.0  
Since that time a donut lens isn't working.

This mapping for this donat is defined with

```auto
    "bq_DMZ": {
      "type": "boolean"
    },

```

With logstash I am importing the data. In two independant pipelines there is a filter with

```auto
    mutate {
            add_field => { "bq_DMZ" => "true" }
    }

```

The other pipeline sets this field to "false".  
Using discover tool I can search for true or false and I get the results.  
But using kibana to create a donat lens brings a strange error, when I move this field over to the "slice by" field. Unfortunatelly it's not possible to copy&paste the error.  
As I said it worked fine before the update.

Any idea what could be the issue ?

// Hans

---

<div class="post-metadata">

**Author:** ![devon.thomson](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/devon.thomson/32/85468_2.png) [@devon.thomson](https://discuss.elastic.co/u/devon.thomson)\
**Post date:** [November 15, 2022, 8:46pm UTC](https://discuss.elastic.co/t/v-8-5-0-update-boolean-field-not-working-in-donut-lens-anymore/318949/2 "2022-11-15T20:46:19Z")

</div>

Running 8.5, I'm unable to reproduce this with a normal boolean type field. Is there anything special about this field? Can you take a screenshot of the error?

---

<div class="post-metadata">

**Author:** ![mayer](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/mayer/32/42164_2.png) [@mayer](https://discuss.elastic.co/u/mayer)\
**Post date:** [November 17, 2022, 1:28pm UTC](https://discuss.elastic.co/t/v-8-5-0-update-boolean-field-not-working-in-donut-lens-anymore/318949/3 "2022-11-17T13:28:21Z")

</div>

![Screenshot 2022-11-17 at 14.25.11](https://us1.discourse-cdn.com/elastic/original/3X/d/e/ded71e24a5ebece4bc5105b0854cb9a67b698934.png)

I hope it is readable. I just moved "bq\_DMZ" from the left side to right field "Sliced by"

// Hans

---

<div class="post-metadata">

**Author:** ![devon.thomson](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/devon.thomson/32/85468_2.png) [@devon.thomson](https://discuss.elastic.co/u/devon.thomson)\
**Post date:** [November 17, 2022, 6:08pm UTC](https://discuss.elastic.co/t/v-8-5-0-update-boolean-field-not-working-in-donut-lens-anymore/318949/4 "2022-11-17T18:08:31Z")

</div>

@Stratoula_Kalafateli, I wonder if this is a migration issue? Do you know if anything has changed with Lens's handling of boolean fields?

---

<div class="post-metadata">

**Author:** ![Stratoula\_Kalafateli](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/stratoula_kalafateli/32/70923_2.png) [@Stratoula\_Kalafateli](https://discuss.elastic.co/u/Stratoula_Kalafateli)\
**Post date:** [November 18, 2022, 6:47am UTC](https://discuss.elastic.co/t/v-8-5-0-update-boolean-field-not-working-in-donut-lens-anymore/318949/5 "2022-11-18T06:47:39Z")

</div>

Nothing that I am aware of. Can you save this visualization with the error on the library, then go to Stack Management --\> Saved Objects and export this visualization and send it to us? Moreover from which version did you update? Thanx!

---

<div class="post-metadata">

**Author:** ![mayer](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/mayer/32/42164_2.png) [@mayer](https://discuss.elastic.co/u/mayer)\
**Post date:** [November 26, 2022, 12:57pm UTC](https://discuss.elastic.co/t/v-8-5-0-update-boolean-field-not-working-in-donut-lens-anymore/318949/6 "2022-11-26T12:57:45Z")

</div>

Dear All,

update was from the last 8.4 version as I do almost always an update when a new version is available. I think it was 8.4.3

Currently I am looking how to send/upload the export json file.

// Hans

---

<div class="post-metadata">

**Author:** ![mayer](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/mayer/32/42164_2.png) [@mayer](https://discuss.elastic.co/u/mayer)\
**Post date:** [November 26, 2022, 12:59pm UTC](https://discuss.elastic.co/t/v-8-5-0-update-boolean-field-not-working-in-donut-lens-anymore/318949/7 "2022-11-26T12:59:32Z")

</div>

```auto
{"attributes":{"fieldAttrs":"{\"geoip.geo.country_iso_code\":{\"count\":1},\"geoip.geo.country_iso_code.keyword\":{\"count\":2},\"bq_DMZ\":{\"count\":2}}","fieldFormatMap":"{\"bq_DMZ\":{\"id\":\"static_lookup\",\"params\":{\"parsedUrl\":{\"origin\":\"http://kibana8.iiasa.ac.at:5601\",\"pathname\":\"/app/management/kibana/settings\",\"basePath\":\"\"},\"lookupEntries\":[{\"key\":\"0\",\"value\":\"internal\"},{\"key\":\"1\",\"value\":\"DMZ\"}],\"unknownKeyValue\":null}},\"bq_querytype\":{\"id\":\"string\",\"params\":{\"parsedUrl\":{\"origin\":\"http://kibana8.iiasa.ac.at:5601\",\"pathname\":\"/app/management/kibana/settings\",\"basePath\":\"\"},\"transform\":\"upper\"}}}","fields":"[]","name":"bindquery-2.0*","runtimeFieldMap":"{}","sourceFilters":"[]","timeFieldName":"@timestamp","title":"bindquery-2.0*","typeMeta":"{}"},"coreMigrationVersion":"8.5.0","id":"67c7b160-2474-11ed-9d10-7bff2f98235f","migrationVersion":{"index-pattern":"8.0.0"},"references":[],"type":"index-pattern","updated_at":"2022-11-15T10:33:32.959Z","version":"Wzc3MzgsMl0="}
{"attributes":{"description":"BindQuery: Location DMZ","state":{"adHocDataViews":{},"datasourceStates":{"indexpattern":{"layers":{"d2a5a381-f6d7-4e63-b960-d473cfd54184":{"columnOrder":["d33811d8-7802-49f3-bbf8-c3f1327041fa","0dbc81cd-e312-41a5-8949-172cdecff415"],"columns":{"0dbc81cd-e312-41a5-8949-172cdecff415":{"dataType":"number","isBucketed":false,"label":"Count of records","operationType":"count","params":{"emptyAsNull":true},"scale":"ratio","sourceField":" ___records___"},"d33811d8-7802-49f3-bbf8-c3f1327041fa":{"dataType":"boolean","isBucketed":true,"label":"Top 5 values of bq_DMZ","operationType":"terms","params":{"missingBucket":false,"orderBy":{"columnId":"0dbc81cd-e312-41a5-8949-172cdecff415","type":"column"},"orderDirection":"desc","otherBucket":true,"parentFormat":{"id":"terms"},"size":5},"scale":"ordinal","sourceField":"bq_DMZ"}},"incompleteColumns":{}}}}},"filters":[],"internalReferences":[],"query":{"language":"kuery","query":""},"visualization":{"layers":[{"categoryDisplay":"default","layerId":"d2a5a381-f6d7-4e63-b960-d473cfd54184","layerType":"data","legendDisplay":"show","legendMaxLines":5,"metric":"0dbc81cd-e312-41a5-8949-172cdecff415","nestedLegend":false,"numberDisplay":"percent","primaryGroups":["d33811d8-7802-49f3-bbf8-c3f1327041fa"]}],"shape":"donut"}},"title":"BindQuery: Name Server Location","visualizationType":"lnsPie"},"coreMigrationVersion":"8.5.0","id":"ff2fea90-2474-11ed-9d10-7bff2f98235f","migrationVersion":{"lens":"8.5.0"},"references":[{"id":"67c7b160-2474-11ed-9d10-7bff2f98235f","name":"indexpattern-datasource-layer-d2a5a381-f6d7-4e63-b960-d473cfd54184","type":"index-pattern"}],"type":"lens","updated_at":"2022-11-26T12:44:26.058Z","version":"Wzk1NzAsMl0="}
{"excludedObjects":[],"excludedObjectsCount":0,"exportedCount":2,"missingRefCount":0,"missingReferences":[]}

```

---

<div class="post-metadata">

**Author:** ![Stratoula\_Kalafateli](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/stratoula_kalafateli/32/70923_2.png) [@Stratoula\_Kalafateli](https://discuss.elastic.co/u/Stratoula_Kalafateli)\
**Post date:** [November 28, 2022, 7:27am UTC](https://discuss.elastic.co/t/v-8-5-0-update-boolean-field-not-working-in-donut-lens-anymore/318949/8 "2022-11-28T07:27:38Z")

</div>

Thanx! It seems that the `bq_DMZ` is a runtime field. Can you send me how you have configured this? To do so, go to the dataviews management page, select your dataview and click the pencil icon on the field. This will open a flyout, we want the `set value` script.

 ![image](https://us1.discourse-cdn.com/elastic/original/3X/2/1/2116bf43fdce95f7aaf3e76bf1fcc613e2ed64b8.png)

---

<div class="post-metadata">

**Author:** ![mayer](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/mayer/32/42164_2.png) [@mayer](https://discuss.elastic.co/u/mayer)\
**Post date:** [November 30, 2022, 3:21pm UTC](https://discuss.elastic.co/t/v-8-5-0-update-boolean-field-not-working-in-donut-lens-anymore/318949/9 "2022-11-30T15:21:46Z")

</div>

Many thanks for your reply.  
Unfortunately I don't have a "set value" tab. This I have. I hope it helps.

 ![Screenshot 2022-11-30 at 16.16.46](https://us1.discourse-cdn.com/elastic/original/3X/9/f/9fb2da9426a15f8567ec954131376df597f8c438.png)

 ![Screenshot 2022-11-30 at 16.14.32](https://us1.discourse-cdn.com/elastic/original/3X/d/1/d1fb9b96e0dcadda4503275148d21edd3b59bd0d.png)

---

<div class="post-metadata">

**Author:** ![mayer](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/mayer/32/42164_2.png) [@mayer](https://discuss.elastic.co/u/mayer)\
**Post date:** [November 30, 2022, 3:25pm UTC](https://discuss.elastic.co/t/v-8-5-0-update-boolean-field-not-working-in-donut-lens-anymore/318949/10 "2022-11-30T15:25:30Z")

</div>

If I remove "set format" then it works. But then I see only true or false.

// Hans

---

<div class="post-metadata">

**Author:** ![Stratoula\_Kalafateli](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/stratoula_kalafateli/32/70923_2.png) [@Stratoula\_Kalafateli](https://discuss.elastic.co/u/Stratoula_Kalafateli)\
**Post date:** [November 30, 2022, 3:44pm UTC](https://discuss.elastic.co/t/v-8-5-0-update-boolean-field-not-working-in-donut-lens-anymore/318949/11 "2022-11-30T15:44:48Z")

</div>

Interesting, so you have a field formatter. I can't replicate it to be honest. I added the same field formatter to a boolean field and I don't see the error.

The formatter is not applied (but this is a bug of 8.5 which will be fixed in 8.6 but I don't see an error)

 ![image](https://us1.discourse-cdn.com/elastic/original/3X/0/2/02e6f8d20337567614ee071fc31620f858e8a102.jpeg)

---

<div class="post-metadata">

**Author:** ![mayer](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/mayer/32/42164_2.png) [@mayer](https://discuss.elastic.co/u/mayer)\
**Post date:** [November 30, 2022, 5:20pm UTC](https://discuss.elastic.co/t/v-8-5-0-update-boolean-field-not-working-in-donut-lens-anymore/318949/12 "2022-11-30T17:20:39Z")

</div>

I just upgraded to 8.5.2 but the situation is unchanged.  
When I set "Set format" to "Static lookup" with key 0 and 1 and values then I get immediately an error. When I remove "Set format" then it's fine.  
I can live with this situation. But definitely it worked with 8.4.something

Is this general the recommended way to view booleans as a text in kibana or do I try to do something unconventionally ?

// Hans

---

<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:** [December 28, 2022, 5:20pm UTC](https://discuss.elastic.co/t/v-8-5-0-update-boolean-field-not-working-in-donut-lens-anymore/318949/13 "2022-12-28T17:20:43Z")

</div>

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